01.
<table id=
"racetimes"
>
02.
<tr id=
"racetimes"
>
03.
<th width=
"200"
>Rec.ID</th>
04.
<th width=
"200"
>ชื่อพนักงาน</th>
05.
<th width=
"200"
>วันที่</th>
06.
<th width=
"200"
>เวลาเข้า</th>
07.
<th width=
"200"
>เวลาออก</th>
08.
<th width=
"200"
>ค่าเกมส์</th>
09.
<th width=
"200"
>ค่าขนม</th>
10.
<th width=
"200"
>ค่าปริ้นท์</th>
11.
<th width=
"200"
>รวมยอด</th>
12.
<th width=
"400"
>รายละเอียด</th>
13.
<th width=
"200"
>หักค่าเกมส์</th>
14.
<th width=
"200"
>หักค่าขนม</th>
15.
<th width=
"200"
>หักค่าปริ้นท์</th>
16.
<th width=
"350"
>ยอดคงเหลือสุทธิ</th>
17.
<th width=
"200"
>ลบข้อมูล</th>
18.
<th width=
"200"
>แก้ไขข้อมูล</th>
19.
</tr>
20.
<?
21.
while
(
$data
= mysqli_fetch_array(
$result
)){
22.
?>
23.
<tr>
24.
<td width=
"200"
><?
echo
$data
[
'record_id'
]; ?></td>
25.
<td width=
"200"
><?
echo
$data
[
'name'
]; ?></td>
26.
<td width=
"200"
><?
echo
$data
[
'date'
]; ?></td>
27.
<td width=
"200"
><?
echo
$data
[
'time_in'
]; ?></td>
28.
<td width=
"200"
><?
echo
$data
[
'time_out'
]; ?></td>
29.
<td width=
"200"
><?
echo
$data
[
'games'
]; ?></td>
30.
<td width=
"200"
><?
echo
$data
[
'dessert'
]; ?></td>
31.
<td width=
"200"
><?
echo
$data
[
'print'
]; ?></td>
32.
<?
$x
=
$data
[
'games'
]+
$data
[
'dessert'
]+
$data
[
'print'
]; ?>
33.
<td width=
"200"
><?
echo
$x
; ?></td>
34.
<td width=
"400"
><?
echo
$data
[
'remark'
]; ?></td>
35.
<td width=
"200"
><?
echo
$data
[
'gameslost'
]; ?></td>
36.
<td width=
"200"
><?
echo
$data
[
'dessertlost'
]; ?></td>
37.
<td width=
"200"
><?
echo
$data
[
'printlost'
]; ?></td>
38.
<?
$y
=
$data
[
'gameslost'
]+
$data
[
'dessertlost'
]+
$data
[
'printlost'
]; ?>
39.
<td width=
"350"
><?
echo
$x
-
$y
; ?></td>
40.
<td width=
"200"
><a href=
"delete.php?RecordID=<? echo $data['record_id']; ?>"
>
Delete
</td>
41.
<td width=
"200"
><a href=
"editrecord.php?RecordID=<? echo $data['record_id']; ?>"
>Edit</td>
42.
</tr>
43.
<? } ?>
44.
</table>