on-line catalogue

[bart]

I am trying to reproduce a catalogue on-line using PHP.
I have no problems gathering all the data I need from my MySQL database, but how can I specify that I only want the HTML table the data is to be displayed in is only 4 columns wide?

If I use the while($query_data = mysql_fetch_array($result))
{
echo "<td etc etc etc...)
}

the table will just be loads of columns and not split into a different row after each 4 columns.

Any ideas?
Thanks

[mayus]

how about :

if (mysql_errno() == 0) $numresults = mysql_numrows($result);
else $numresults = 0;

if ($numresults > 0)
{   
  print "<table>";
  print "  <tr>"; 
}

for ($i=0; $i<$numresults; $i++)
{
   if ( ((i%4) == 0) && ($i != 0) ) print "</tr><tr>";

   echo "<td etc etc etc...) 
}

if ($numresults > 0)
{   
  print "</tr>";
  print "  </table>"; 
}

Hope it helps.

Cheers,

Mayu