PHP mySQL data output problem

I am creating a ecommerce site and the product display page is not comming out the way I would like it to

take a look

I want it to start a new table row if there are more than 4 products and for every 4 products the table must have a new row.

if there are 9 products it should look like this

[] [] [] []
[] [] [] []
[]

like a grid output

What should I do please help me

[himakumar]

Hi,

which way u r getting the products info for displaying, from database or else

if u r getting from database
while loop
<tr>
for loop condition<4 or take =4
<td>product</td>
end for
</tr>
end while

[hakperest]

I think that it will be good for you that use mysql for your data

[neriksmoen]

you would probably want to do something such as:

$query = @mysql_query("SELECT * FROM yourtable");
echo "<table border=1 cellpadding=0 cellspacing=0>";
echo " <tr>";
$thenum = 1;
while($result = @mysql_fetch_array($query))
{
  if($thenum > 4){ $thenum=1; echo "</tr><tr>"; }
  else{ $thenum++; }
  echo "<td>$result[thefield]</td>";
}
echo " </tr>";
echo "</table>";

which is similar to what himakumar was suggesting code-wise, and using the database that hakperest suggested.