[mdhall]

I havent found an image gallery yet that is quite what I want. I want to take the following query....

PHP Code:

$used = ("SELECT * FROM used_units LIMIT 9");
$result2=mysql_query($used);
$num2=mysql_num_rows($result2);
$i = 0;
while ($i < $num):
$year=mysql_result($result2,$i,"year");
$model=mysql_result($result2,$i,"model");
$tag_line=mysql_result($result2,$i,"tag_line");
$photo=mysql_result($result2,$i,"photo"); 
$i++; 
endwhile; 
echo "<table border=\"1\" width=\"680\" cellpadding=\"2\" cellspacing=\"0\">
<tr>
<td width=\"700\" valign=\"middle\" align=\"center\">
<font face=\"verdana, times\" size=\"2\" color=\"#000000\">";
include("scale2.php");
echo "<br>
$year $division $model<br>$tag_line</font></td></table>"; 

...and create an image gallery with only nine pictures showing, 3 rows with 3 pictures in each row. I want the picture and its information together in the same "cell" and repeat that for each row of pictures. The pictures are in a folder named "used_units" and the pictures corresponding info is in the database, $photo being the pictures name. The scale2.php script limits the pictures display size.

I've tried different snippets of code for this, but can't get any tos et up correctly or display the way I want them to. Any suggestions on how to modufy this script?