01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
04.</head>
05.<body>
06.<?
07.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
08.$objDB = mysql_select_db("mydatabase");
09.
10.$strSQL0 = "SELECT * FROM customer WHERE Status = '0' ";
11.$objQuery0 = mysql_query($strSQL0) or die ("Error Query [".$strSQL0."]");
12.$numrows = mysql_num_rows($objQuery0);
13.if($numrows <= 0)
14.{
15. $strSQL00 = "UPDATE customer SET Status = '0' ";
16. $objQuery00 = mysql_query($strSQL00) or die ("Error Query [".$strSQL00."]");
17.}
18.
19.$strSQL = "SELECT * FROM customer WHERE Status = '0' ORDER BY RAND() LIMIT 2 ";
20.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
21.?>
22.<table width="600" border="1">
23. <tr>
24. <th width="91"> <div align="center">CustomerID </div></th>
25. <th width="98"> <div align="center">Name </div></th>
26. <th width="198"> <div align="center">Email </div></th>
27. <th width="97"> <div align="center">CountryCode </div></th>
28. <th width="59"> <div align="center">Budget </div></th>
29. <th width="71"> <div align="center">Used </div></th>
30. </tr>
31.<?
32.while($objResult = mysql_fetch_array($objQuery))
33.{
34.?>
35. <tr>
36. <td><div align="center"><?=$objResult["CustomerID"];?></div></td>
37. <td><?=$objResult["Name"];?></td>
38. <td><?=$objResult["Email"];?></td>
39. <td><div align="center"><?=$objResult["CountryCode"];?></div></td>
40. <td align="right"><?=$objResult["Budget"];?></td>
41. <td align="right"><?=$objResult["Used"];?></td>
42. </tr>
43.<?
44.$strSQL2 = "UPDATE customer SET Status = '1' WHERE CustomerID = '".$objResult["CustomerID"]."' ";
45.$objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
46.}
47.?>
48.</table>
49.<?
50.mysql_close($objConnect);
51.?>
52.</body>
53.</html>
