Dividing Mysql results

[lastuser]

I do the image gallery and it is almost ready. There is a one "little" problem anymore. How can I get Mysql results 4 per lines like this..

printing from mysql..

Getting information by while loop..

<tr>
<td>pic1</td><td>pic2</td><td>pic3</td><td>pic4</td>
</tr>

<tr>
<td>pic5</td><td>pic6</td><td>pic7</td><td>pic8</td>
</tr>
.
.
.
This is too diffcult to me. I purpose that this script works for Example foreach but how?? Thanks for the help!!

[bastien]

<?
$x=1; //initialize the counter
do while ($row=mysql_fetch_array($result)){
$pic = $row["pic"];

if ($x==1){
   echo "<tr><td>$pic</td>";
   $x=$x+1;
}elseif (($x==2)||($x==3)){    // middle pics [B]<==needed two equal signs to make it go, and a check for x=3...whoops[/B] 
    echo "<td>$pic</td>";
   $x=$x+1;
}elseif ($x==4){
   echo "<td>$pic</tc></tr>";
   $x=1;
}

}

?>

hth

[lastuser]

There is some kind of problem. If I have more than four picture it makes just more <td></td> and after that comes </tr>. I think that problem is do while . It doesn't work if I don't take "do" away. Could you check the script.. I would be grateful!

[bastien]

.

[lastuser]

Thank you! That script is really great!!