MySQL, PHP, and tables

[Anon]

I used the following code (basically from Wrox - Professional PHP Programming) to display search contents in a table. The table is only 1 column wide and the pages are getting mighty long. I'd like to get 3 sets of data (3 columns) to display across the page. Could someone give me a clue? - Thanks -

printf("<table border=0 cellpadding=2 cellspacing=6
BGCOLOR=\"#ffeeee\">\n");

while (($row = mysql_fetch_object($result))){

printf("<tr><td valign=\"top\"><font face=\"arial, helvetica,
sans-serif\" SIZE=\"-1\">%s <br>%s, %s <br>%s, %s %s <br>%s <br>%s
<br></font></td>\n",

$row->store, $row->address, $row->address2, $row->city, $row->state,
$row->zip, $row->country, $row->phone);
}
printf("</table>\n");

[Anon]

Simply add more columns to your table by outputting three data items at a time either using a counter in your loop or manually grabbing more data from the mysql result by adding extra $row = mysql_fetch_object() lines each time you want to populate a cell. Example:

printf("<table border=0 cellpadding=2 cellspacing=6
BGCOLOR=\"#ffeeee\">\n");

while (($row = mysql_fetch_object($result))){

printf("<tr>");

printf ("<td valign=\"top\"> sans-serif\" SIZE=\"-1\">%s <br>%s, %s <br>%s, %s %s <br>%s <br>%s
<br></td>\n",

$row->store, $row->address, $row->address2, $row->city, $row->state,
$row->zip, $row->country, $row->phone);

$row = mysql_fetch_object ($result);
if ($row)
printf ("<td valign=\"top\"> sans-serif\" SIZE=\"-1\">%s <br>%s, %s <br>%s, %s %s <br>%s <br>%s
<br></td>\n",

$row->store, $row->address, $row->address2, $row->city, $row->state,
$row->zip, $row->country, $row->phone);
else
echo "<td>&nbsp;</td>";

$row = mysql_fetch_object ($result);
if ($row)
printf ("<td valign=\"top\"> sans-serif\" SIZE=\"-1\">%s <br>%s, %s <br>%s, %s %s <br>%s <br>%s
<br></td>\n",

$row->store, $row->address, $row->address2, $row->city, $row->state,
$row->zip, $row->country, $row->phone);
else
echo "<td>&nbsp;</td>";

echo "</tr>";
}
printf("</table>\n");

[Anon]

Even easier why not try:

printf("<table border=0 cellpadding=2 cellspacing=6 BGCOLOR=\"#ffeeee\">\n");

  while (($row = mysql_fetch_object($result))){ 

printf ("<tr><td valign=\"top\">%s </td><td>%s, %s </td><td>%s, %s %s</td><td>%s </td><td>%s</td></tr>\n", $row->store, $row->address, $row->address2, $row->city, $row->state, $row->zip, $row->country, $row->phone);

         } 

printf("</table>\n");

[Anon]

That's exactly what he had before. He needed 3 columns.