Incrementing Image Results

Anon

I am trying to display my results from a mysql database that has hrefs to images
in the table
$result = mysql($dbName,"Select ThumbnailURL, MoreInfo FROM instock_bath WHERE CategoryCode='B'");
I only have five rows in my database for testing, and it returns the correct number of rows, however, it returns only the first image 5 times and does not increment to the next image. It does the row and columns fine except for the fact it only shows the same image. How do I get it to show image 1, then image 2, etc.

The code I am is using is below:
Thanks in advance.

//initialize variables

$num_rows = 5;
$photos_per_row = 4;
$photos = mysql_num_rows($result);
$total_photos = mysql_num_rows($result);
$photos_per_page = $num_rows * $photos_per_row;
//check to see if the start variable exists in the URL.

//If not, then the user is on the first page - set start to 0
if(!isSet($start)){
$start = 0;
}
//init i to where it needs to start in the photos array
$i = $start;
$prev_start = $start - $photos_per_page;
$next_start = $start + $photos_per_page;
while ($row=mysql_fetch_array($result)) {
for ($row=0; $row < $num_rows; $row++) {
print("<tr>\n");
for ($col=0; $col < $photos_per_row; $col++){
if($i < $total_photos){
$thumb=mysql_result($result,"ThumbnailURL");
$more=mysql_result($result2,"MoreInfo");
print("<td align=\"center\"
\"".$thumb.
"".$more."</td>\n");
} else {
print("<td></td>\n");
}
$i++;
}
print("</tr>\n");
}
}
?>

Anon

Let me guess

You have a table that contains pictures. It has 4 pictures per row in a table and table has five rows and you are trying to retrieve all the pictures??? Am I correct.

If yes, then

This is how you can do it...

$result=mysql_query("You query...", $connection);

while($res=mysql_fetch_array($result))
{
echo "<tr><td>$res[field1]</td></td>$res[field2]</td>....</tr>";
}

mysql_fetch_array() retrives one row at a time and stores it into $res. name of fields in a table is a key to access data from $res, because result is an associative array.

If you have table with names picture1, picture2, and picture3. Then to access you do $res[picture1], etc...