thanks for the reply GaRHaR
the database is mysql driven and im projecting the info with PHP,
I have now managed to get the grid displaying 3x3 but for some reason it's displaying more than 9 images.
this is the code im using
Code:
print "<h3><b>Browsing items in the Gallery...</b></h3>";
$cnt=mysql_query("SELECT gID FROM galleryitems",$c);
$pics=mysql_num_rows($cnt);
$pages=(int) ($pics/9)+1;
if($pics % 9 == 0)
{
$pages--;
}
print "Pages: ";
for($i=1;$i <= $pages;$i++)
{
$stl=($i-1)*9;
print "<a href='gallery.php?by=$by&ord=$ord'>$i</a> ";
}
$q=mysql_query("SELECT gi.*,i.* FROM galleryitems gi LEFT JOIN items i ON gi.gITEMID=i.itmid ORDER BY i.itmtype ASC, i.itmbuyprice ASC, i.itmname ASC LIMIT 9",$c) or die(mysql_error());
$no1=$st+1;
$no2=$st+9;
print"
Showing users $no1 to $no2 by order of $by $ord.
<table width=75% border=2>";
while($r=mysql_fetch_array($q))
{
print "<tr><td><img src='{$r['itmpic']}' width='75' height='75'><br />{$r['itmname']}</td>";
print "</tr>";
}
print "</table>";
PC Help Forum
» Web & Networking
» Web Design
»
fetch array in a 3x3 table
fetch array in a 3x3 table
Linear Mode
