Listing Photos with php and mysql?

[wipeskim]

Hi

I am developing an image bank i allready have the database built and a layout test for showing the photos and categorys.

My problem is that all the pictures they show one under other and what i want to do is list the photos in 3 rows and 4 columns.

My following code that i am using is:

$sql = "select * from $table where categoria='$maingroup' ";

while($row = mysql_fetch_row($sql)) {

printf("<img src='%s' width='160' align='center' border=0>",$resultado["foto"]);

}

If anyone can help me i appreciate.

Thanks to you all.

[devinemke]

spool the results into an array and then use [man]array_chunk[/man] to split the array into chunks of 4.