Query results in a table - Newbie

Anon

Hi, I am using the following code to produce a list of surnames:-

$result = mysql_query(\"SELECT DISTINCT surname FROM tblIndividual WHERE surname LIKE \'A%\' ORDER BY surname ASC\",$db);
if ($myrow = mysql_fetch_array($result)) {

	do { 

	printf(\"%s \\n<br>\", $myrow[\"surname\"]);
	} while ($myrow = mysql_fetch_array($result));

however I would like to display the results in a table with 5 columns. Can anyone help me? I have managed to get the results to repeat for 5 columns then the next result on the next line, eg.

but obviously that is no good. What I would like is:

ABBY | ALES | ANDY | APAN | AZAR

Please help.

Anon

try this:

$result = mysql_query("SELECT DISTINCT surname FROM tblIndividual WHERE surname LIKE 'A%' ORDER BY surname ASC",$db);

if ($myrow = mysql_fetch_array($result))
{
echo "<table><tr>";
do
{
echo "<td>".$myrow["surname"]."</td>");
}while ($myrow = mysql_fetch_array($result));
echo "</tr></table>";

that will write a table out with 5 columns and your results in each column.

hope this helps!

leon

Anon

Hi Leon, thanks for the quick reply, but I can't seem to get that piece of code to work, I just get an error.

One other point I should have made in my original post is that there are more than 5 surnames, I would just like to show them in rows of 5.

Thanks again