01.<?
02. $objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
03. $objDB = mysql_select_db("mydatabase");
04. $strSQL = "SELECT * FROM gallery_group ";
05. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
06. while($objResult = mysql_fetch_array($objQuery))
07. {
08.?>
09. <div class="<?=$objResult["GalleryName"];?>">
10. <ul>
11. <?
12. $strSQL2 = "SELECT * FROM gallery_detail WHERE GroupID = '".$objResult["GalleryID"]."' ";
13. $objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
14. while($objResult2 = mysql_fetch_array($objQuery2))
15. {
16. ?>
17. <li><img src="<?=$objResult2["Detail_Image_Path"];?>" /></li>
18. <?
19. }
20. ?>
21. </ul>
22. </div>
23.<?
24. }
25. mysql_close($objConnect);
26.?>
