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.$strSQL = "SELECT * FROM customer";
10.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
11.?>
12.<table width="600" border="1">
13.<tr>
14.<th width="91"> <div align="center">CustomerID </div></th>
15.<th width="98"> <div align="center">Name </div></th>
16.<th width="198"> <div align="center">Email </div></th>
17.<th width="97"> <div align="center">CountryCode </div></th>
18.<th width="59"> <div align="center">Budget </div></th>
19.<th width="71"> <div align="center">Used </div></th>
20.</tr>
21.<?
22.$i=0;
23.while($objResult = mysql_fetch_array($objQuery))
24.{
25.$i++;
26.if($i%2==0)
27.{
28.$bg = "#CCCCCC";
29.}
30.else
31.{
32.$bg = "#FFFFFF";
33.}
34.?>
35.<tr bgcolor="<?=$bg;?>">
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.}
45.?>
46.</table>
47.<?
48.mysql_close($objConnect);
49.?>
50.</body>
51.</html>
ขอบคุณครับ
