|
|
|
ใช้คำสั่ง SELECT เลือกข้อมูลจังหวัด และต้องการจะเลือกเขตย่อยๆๆในจังหวัด ใช้คำสั่งอะไรหรอครับ |
|
|
|
|
|
|
|
ขอบคุณครับบบบบบบบบบ
|
|
|
|
|
Date :
2013-12-06 11:34:55 |
By :
thepaysz |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Date :
2013-12-07 07:42:48 |
By :
mr.win |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Code (PHP)
<?
$query1 = mysql_query("SELECT * FROM (Customers INNER JOIN Car on Customers.ID_CUSTOMERS = Car.ID_CUSTOMERS)WHERE Customers.ID_CUSTOMERS = '$ID_CUSTOMERS'");
$query2 = mysql_query("SELECT * FROM Bill JOIN Car ON Car.ID_CAR = Bill.ID_CAR");
$rows1 = mysql_fetch_array($query2);
?>
<table width='80%'>
<tr align='center'>
<?
while($rows = mysql_fetch_array($query1))
{
?>
<td>
<div onClick="window.location='EditCarFrom.php?EditCar_id=<?=$rows[$ID_CAR]?>'">
<table class="tablea">
<tr align='left'>
<td width='400' colspan='2' valign='top'>เลขทะเบียน $rows[$Car_Regis]</td>
</tr>
<tr align='left'>
<td width='200' valign='top'>$rows[$Car_Brand]</td>
<td width='200' valign='top'>$rows[$Car_Gen]</td>
</tr>
<tr align='left'>
<td width='400' colspan='2' valign='top'>สถานะรถ $rows1[$Status_Bill]</td>
</tr>
</table>
</div>
</td>
}
</tr>
</table>
|
|
|
|
|
Date :
2013-12-07 11:37:05 |
By :
nono |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 04
|