printing products in columns

Anon

I am know this is very general and a newbie question, I am very new to PHP and server side scripting in general.

Any way I have a group of products that I want to display three to a column and I am having trouble getting my results to work,

for ($ROW=1; $ROW <= 10; $ROW ++)
{
	print ("<tr>\n");  

		for ($COLUMN=1; $COLUMN <= 2; $COLUMN ++)
		{
  while ($row = mysql_fetch_array($sql_result)) 	{

				$product_id = $row["product_id"];
				$name = $row["name"];
				$sm_img_src = $row["sm_img_src"];


			print ("<td>");
			print ("<center><a href=\"product_detail.php3?product_id=$product_id\"><img src=\"images/$sm_img_src\" border=\"0\"><br>$name</a></center>");
			print ("</td>");
		  }	
		}

	print ("<tr>\n");

}

Of course this only prints out cells in one row for how ever many products there is.

Thanks for any help,

jake

Anon

Change the varibales $cols to be whatever number of columns you want

<?php
echo "<table border=1><tr>";
$cols = 3;
$counter = 1;
while ($row = mysql_fetch_array($sql_result)) {

$product_id = $row["product_id"];
$name = $row["name"];
$sm_img_src = $row["sm_img_src"];

if (is_int($counter / $cols)) {

print ("<td>");
print ("<center><a href=\"product_detail.php3?product_id=$product_id\"><img src=\"images/$sm_img_src\" border=\"0\"><br>$name</a></center>");
print ("</td></tr><tr>");

}

else {

print ("<td>");
print ("<center><a href=\"product_detail.php3?product_id=$product_id\"><img src=\"images/$sm_img_src\" border=\"0\"><br>$name</a></center>");
print ("</td>");

}

$counter++;

}

echo "</tr></table>";