Need Help, to display pics

[wcecil]

Need some help on displaying pics on a page, the pics are uploaded to a database "mysql". I'm able to display one column of pics, but what i really need is to display 3 columns and 3 rolls for a total of nine pics. I already have created the code for first, next, last for the pages of more than nine pics, just need some help on creating the 3 columns and 3 rolls, code

Thanks

[rIkLuNd]

<?php

$OneRow = 3;

// First let's check if there are any records in the database
## Connection Stuff ##
$get = mysql_query("select * from table");
$rows = mysql_num_rows($get);

if($rows > 0)
{
echo "<table>\n";
$column = 1;
while($result = mysql_fetch_array($get))
{
if(($column % $OneRow) == 1)
echo "<tr>\n";

echo "<td>\n";
echo "<img src=\"images/".$result['name']."\">\n";
echo "</td>\n";

if(($column % $OneRow) == 0)
echo "</tr>\n";

$column++;
}

// This will fill the empty columns
while(($column % $OneRow) != 0)
{
echo "<td>&nbsp;</td>\n";
if(($column % $OneRow) == 0)
echo "</tr>\n";
break;
}

$column++;
}

echo "</table>\n";
}

?>

[wcecil]

How can I user command line in the code that you sent.

<a href="product_details.php?id={id}&amp;product_id={product_id}"><img src="{thumbsrc}" width="{thumbwidth}" height="{thumbheight}" alt="{View_product_details}"></a>

Thanks

[wcecil]

By the way this in on a called iHTML page.

Thanks

[rIkLuNd]

don't know... sorry!