01.<html>
02.<head>
03.<title>ThaiCreate.Com Tutorial</title>
04.</head>
05.<body>
06.
07. <?
08. $objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
09. $objDB = mysql_select_db("mydatabase");
10. $strSQL = "SELECT * FROM files";
11. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
12. echo"<table border=\"0\" cellspacing=\"1\" cellpadding=\"1\"><tr>";
13. $intRows = 0;
14. while($objResult = mysql_fetch_array($objQuery))
15. {
16. $intRows++;
17. echo "<td>";
18. ?>
19. <table width="91" border="0" cellspacing="0" cellpadding="0">
20. <tr>
21. <td><div align="center"><a href="myfile/<?=$objResult["FilesName"];?>" target="_blank"><img src="myfile/<?=$objResult["FilesName"];?>" width="100" height="100" border="0"></a></div></td>
22. </tr>
23. </table>
24. <?
25. echo"</td>";
26. if(($intRows)%2==0)
27. {
28. echo"</tr>";
29. }
30. else
31. {
32. echo "<td>";
33. }
34. }
35. echo"</tr></table>";
36. ?>
37. <?
38. mysql_close($objConnect);
39. ?>
40.
41.</body>
42.</html>
