UBB.Developers Forums Community Development Programming MySQL and Server Configuration how do I return more then one

ok I'v been working on a little image gallery
but my query is only returning 1 image with comment

code:
// do query for user images ,comments------------------------------------------------- 
$query = " 
	  SELECT G_username,G_image,G_comments 
	  FROM   w3t_Gallery 
          WHERE G_username = '$Username' 
	 "; 
	  $sth2 = $dbh -> do_query($query); 
	  list ($Username,$Gimage,$Gcomments) = $dbh -> fetch_array($sth2); 
	  $dbh -> finish_sth($sth2); 
	  $Pic = "<img width=200 height=150 src = "$Gimage" alt="$Username">"; 
 
// end do query for user image ,comments--------------------------------------------  

---

code:
 
echo"<TR><TD><a href="$Gimage">$Pic<br><center>$Gcomments</center></TD></TR></TABLE>";

---

now there are 5 results it should return but only retuning 1

help can you see what I did wrong

You need a loop:

code:
// do query for user images,comments
$query = " 
   SELECT G_username,G_image,G_comments
   FROM   w3t_Gallery 
   WHERE  G_username = '$Username'
   ";
$sth2 = $dbh -> do_query($query);		
// end do query for user image,comments

while (list ($Username,$Gimage,$Gcomments) = $dbh -> fetch_array($sth2)) {
   $Pic = "<img width=200 height=150 src = "$Gimage" alt="$Username">";
   echo"<TR><TD><a href="$Gimage">$Pic<br><center>$Gcomments</center></TD></TR></TABLE>";
}
$dbh -> finish_sth($sth2);

---

ok got ya
Thank you

humm if you don't mind can you tell me how to limit to 4 images per row ,after displaying 4 images & want it to go next line.


sorry I'm new to this & this is my first program
but I'm trying guess thats what counts


edit never mind I got it