Dropping data into two HTML columns

[Anon]

I have done a few searches on this and can not seem to come up with anything that is an answer to what I am trying to do.

I need data from a MySql db to populate the left then the right column of a single HTML table and repeat this until the entire contents of the MySql table have been displayed --- and I want to have this only display in 10 row incriments -- then put thos little numbers at the bottom for "pages".

This is the the table that I have working but it is only a single column:

$i = 0;

while ($i < mysql_num_rows($mysql_result))

{

$name = mysql_result($mysql_result,$i,"name");

$company_name = mysql_result($mysql_result,$i,"company_name");

$address = mysql_result($mysql_result,$i,"address");

$city = mysql_result($mysql_result,$i,"city");

$state = mysql_result($mysql_result,$i,"state");

$zip = mysql_result($mysql_result,$i,"zip");

$a_c = mysql_result($mysql_result,$i,"a_c");

$prefix = mysql_result($mysql_result,$i,"prefix");

$suffix = mysql_result($mysql_result,$i,"suffix");

$email = mysql_result($mysql_result,$i,"email");

print("<TABLE WIDTH=\"100%\" CELLSPACING=\"1\">\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$name</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$company_name</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$address</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$city</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$state</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">$zip</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\">($a_c) $prefix - $suffix</TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD COLSPAN=\"3\"><FONT FACE=\"Arial, Helvetica, sans-serif\" SIZE=\"-1\"><A HREF=\"mailto:$email\">$email</A></TD>\n");

print("</TR>\n");

print("<TR>\n");

print("<TD>&nbsp;</TD>\n");

print("</TR>\n");

print("</TABLE>\n");

$i ++;

}

I am a newbie at this so any help would be appreciated

[tsmith]

It looks fine. Just print it differently.
try this:
<?php
echo"<table width='100' cellspacing='1'>\n
<tr>\n
<td>$name</td><td>$company_name</td>\n
</tr>\n";

ect...

</table>\n"
?>

[wit77]

This just creates a second column for the same record ---- I want each record in it's own column ---

I got it working --- I am sure my code is very ugly --- I am not a programmer.

Thanks for you input.

WIT