displaying data

[Anon]

Hi,

My database driven web site using mysql/php is coming along. I now have data displayed correctly in the browser but each item is on a row of it's own whereas I need four items on three rows. Can anyone point me in
the right direction? Here is my code:

<table align='center' border='1' cols='4' width='600px'>
<?php

error_reporting(E_ALL ^ E_NOTICE);

$db = mysql_connect("localhost", "root");

mysql_select_db("frame",$db);

$result = mysql_query("SELECT * from items", $db);

$count = mysql_num_rows($result);

if($count>0) {
while($row=mysql_fetch_array($result)) {
print("<tr><td width='150px' colspan='1'>");
printf("<img src='Images/thumb/%s'></td>",
$row["ItemFull"], $row["ItemThumb"]);

}

}

?>
</table>

Thanks in advance,
Dee

[Anon]

Change this:

if($count>0) {
while($row=mysql_fetch_array($result)) {
print("<tr><td width='150px' colspan='1'>");
printf("<img src='Images/thumb/%s'></td>",
$row["ItemFull"], $row["ItemThumb"]);

}

To this:

if($count>0) {
$col = 0;
while($row=mysql_fetch_array($result)) {
if ($col == 0) {
print "<tr>";
}
$col++;
print("<td width='150px' colspan='1'>");
printf("<img src='Images/thumb/%s'></td>",
$row["ItemFull"], $row["ItemThumb"]);

if ($col == 4) {
print "</tr>";
$col = 0;
}
}

There are nicer ways of doing this, but this fits into your code with only minor changes.