01.
<?
include
(
'config.inc.php'
);
02.
$sql_show
=
"select * from Datametertotal where Name = 'DBP - F1'"
;
03.
$result_show
= mysql_query(
$sql_show
)
or
die
(mysql_error());
04.
while
(
$row_show
=mysql_fetch_array(
$result_show
))
05.
{
06.
?>
07.
<?
include
(
'config.inc.php'
);
08.
$id
=
$row_show
[
'ID'
];
09.
$n
=
'F1-DBP'
;
10.
$strSQL
=
"UPDATE Datametertotal SET"
;
11.
$strSQL
.=
"Name = $n"
;
12.
$strSQL
.=
"where ID = $id"
;
13.
$objQuery
= mysql_query(
$strSQL
);
14.
if
(
$objQuery
)
15.
{
16.
echo
"Save Done."
;
17.
}
18.
else
19.
{
20.
echo
"Error Save ["
.
$strSQL
.
"]"
;
21.
}
22.
?>
23.
<table width=
"200"
border=
"1"
>
24.
<tr>
25.
<td><?=
$row_show
[
'Name'
]?></td>
26.
<td><?=
$row_show
[
'ID'
]?></td>
27.
<td> </td>
28.
</tr>
29.
</table>
30.
<?
31.
}
32.
?>