01.<html>
02.<head>
03.<title>ThaiCreate.Com 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 album";
10. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
11. echo"<table border=\"1\" cellspacing=\"1\" cellpadding=\"1\"><tr>";
12. $intRows = 0;
13. while($objResult = mysql_fetch_array($objQuery))
14. {
15. echo "<td>";
16. $intRows++;
17. ?>
18. <center>
19. <a href="show_gallery.php?AlbumID=<?=$objResult["AlbumID"];?>"><img src="myfile/<?=$objResult["AlbumShot"];?>" width="100" height="100"></a><br>
20. <?=$objResult["AlbumName"];?>
21. <br>
22. </center>
23. <?
24. echo"</td>";
25. if(($intRows)%3==0)
26. {
27. echo"</tr>";
28. }
29. }
30. echo"</tr></table>";
31.
32. mysql_close($objConnect);
33. ?>
34.</body>
35.</html>
