I have a database of images. In it is their thumbnail URL, their full-res URL, their caption and their ID (auto-increment).
This is what my code looks like for the thumbnail page:
<pre>
while ($myrow = mysql_fetch_row($result)) {
?>
<a href=http://www.phpbuilder.com/board/archive/index.php/"pics/full/showpic.php?id=<?php echo $myrow[0]?>">
<img src="<?php echo $myrow[1]?>" border=0"
alt="<?php echo $myrow[3];?>">
</a>
<?php
}
</pre>
And I need a way to make sure that only prints the first 15 rows of data, is there a way to do that w/o making another table for each set of 15?
This is what my code looks like for the thumbnail page:
<pre>
while ($myrow = mysql_fetch_row($result)) {
?>
<a href=http://www.phpbuilder.com/board/archive/index.php/"pics/full/showpic.php?id=<?php echo $myrow[0]?>">
<img src="<?php echo $myrow[1]?>" border=0"
alt="<?php echo $myrow[3];?>">
</a>
<?php
}
</pre>
And I need a way to make sure that only prints the first 15 rows of data, is there a way to do that w/o making another table for each set of 15?