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@xxxxxxxxx> To: php-general@xxxxxxxxxxxxx> Subject: 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
