01.<?
02. $query1 = mysql_query("SELECT * FROM (Customers INNER JOIN Car on Customers.ID_CUSTOMERS = Car.ID_CUSTOMERS)WHERE Customers.ID_CUSTOMERS = '$ID_CUSTOMERS'");
03. $query2 = mysql_query("SELECT * FROM Bill JOIN Car ON Car.ID_CAR = Bill.ID_CAR");
04. $rows1 = mysql_fetch_array($query2);
05.?>
06.<table width='80%'>
07.<tr align='center'>
08.<?
09.while($rows = mysql_fetch_array($query1))
10.{
11.?>
12. <td>
13.
14. <div onClick="window.location='EditCarFrom.php?EditCar_id=<?=$rows[$ID_CAR]?>'">
15. <table class="tablea">
16.
17. <tr align='left'>
18. <td width='400' colspan='2' valign='top'>เลขทะเบียน $rows[$Car_Regis]</td>
19. </tr>
20. <tr align='left'>
21. <td width='200' valign='top'>$rows[$Car_Brand]</td>
22. <td width='200' valign='top'>$rows[$Car_Gen]</td>
23. </tr>
24. <tr align='left'>
25. <td width='400' colspan='2' valign='top'>สถานะรถ $rows1[$Status_Bill]</td>
26. </tr>
27.
28. </table>
29. </div>
30. </td>
31.}
32.</tr>
33. </table>
