HowTo use images with MySQL database

[arquint]

I've a big question!

1. Question:

Can I upload more than one image at the same time in a MySQL database? Like an uploadarray or some thing like that.

2. Question:

I've a script to get images out from a MySQL database. But, I like to format the output in a spezial way and i don't know how.
I'd like to view 10 images for the first line and the next 10 images for the secound line and so far...
I've tried somthing with a DO...WHILE and FOR but it doesn't work.

Please help!

Andy

[bastien]

1. first don't store images in db....performance issues and size issues abound...best to store the image in a folder and store the text path to the image in db...quicker results and better db handling....

2. a simple if loop will make this go...

$x=1;
while ($rows=mysql_fetch_array($result)){

if (($x=1)
echo "<tr>"; //open table row
}
if ($x=10){
echo "</tr>"; //close table row
$x=1; //resset counter
}
echo "<td>$image</td>";
$x++;
} //end while loop