01.
<?
02.
$i
=1;
03.
while
(
$objResult
= mssql_fetch_array(
$objQuery
))
04.
{
05.
?>
06.
<?
if
(
$bg
==
"white"
)
07.
{
08.
$bg
=
"#99FFCC"
;
09.
}
else
{
10.
$bg
=
"white"
;
11.
}
12.
?>
13.
<tr bgcolor=
"<?=$bg?>"
>
14.
<td align=
"center"
><?=
$i
;?></td>
15.
<td><?=
$objResult
[
"mem_thname"
];?></td>
16.
<td><?=
$objResult
[
"mem_thsurname"
];?></td>
17.
<td><?=
$objResult
[
"mem_enname"
];?></td>
18.
<td><?=
$objResult
[
"mem_ensurname"
];?></td>
19.
<td><?=
$objResult
[
"mem_username"
];?></td>
20.
<td><?=
$objResult
[
"mem_password"
];?></td>
21.
<td align=
"center"
><?=
$objResult
[
"depart"
];?></td>
22.
<td align=
"center"
><a href=
"user_edit.php?Mem_1=<?=$objResult["
id
"];?>"
><img src=
"edit.gif"
alt=
"แก้ไข"
></a></td>
23.
<td align=
"center"
><a href="JavaScript:
if
(confirm(
'Confirm Delete?'
)==true){window.location='user_delete.php?Mem_1=
24.
<?=
$objResult
[
"id"
];?>';}
"><img src="
delete
.gif
" alt="
ลบ"></a></td>
25.
</tr>
26.
<?
27.
$i
=
$i
+1;
28.
}
29.
?>