RE: [PHP] Create a matrix gallery

Hotmail sucks but try this [code] $counter = 1; while ($rows=mysql_fetch_assoc($getpic)) { //close the tr tag after 5 photos usng the mod function to check the counter if($counter % 5 == 0) { echo ""; //reset the counter $counter = 1; } extract ($rows); echo ""; echo ""; $counter++; } hth bastien } ?> ----------------------------------------> Date: Mon, 3 Sep 2007 04:30:29 -0400> From: jiuman@gmail.com> To: php-general@lists.php.net> Subject: [PHP] Create a matrix gallery>> hi list. I wonder if anyone can help me with this..> i have a database with the file name of several images stored in a> filesystem, and I want to create a table containing the image results of a> query.>> this is my code>> include_once("../../../connection/connection.php");> ?>> > > Image Gallery> >> > //get the thumbsnails> $getpic=mysql_query("select * from rsiis_images")> or die(mysql_error());>>> while ($rows=mysql_fetch_assoc($getpic))> {> extract ($rows);> echo "";> echo " src=".$ImageThumb.$rows['image_id'].".jpg>";> }> ?>>> >> > > >> With this code, I am able to see the thumb images with their respective link> ok, but if I have a query with 40 results, I will have a big row of images.> ____________________________________________________>> |pic1 | pic2 | pic3 | pic4 | pic5 | pic6 | pic7 | pic8 | pic9 | pic10 |> ______________________________________________________>>> What I want to to do is insert a new after showing 5 thumb images, and> continue with the next picture on the next row.> something like this> __________________________> |pic1 | pic2 | pic3 | pic4 | pic5 |> __________________________> |pic6 | pic7 | pic8 | pic9 | pic10 |> __________________________> |pic11 | pic12 | pic13 |> __________________>>>> Thanks in advance.> Yamil _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE