query results in 2 columns?

I'm struggling to figure out how to do this properly. I have done a mySQL
query to extract a list of names, and done a mysql_num_rows to determine how
many results I've gotten. I want to split the list in to two columns. I've
created $percol = $mysql_num_rows/2 but I'm not quite sure how to "loop"
through the first half of the list, echo </td><td> and then list the
balance. Can anyone give me some guidance on how best to structure this?

Thanx!
Wm

re: query results in 2 columns?

"Wm" <LAshooter@hotmail.com> schreef in bericht
news:xMd3b.556$hf5.10192@news.easynews.com...[color=blue]
> I'm struggling to figure out how to do this properly. I have done a mySQL
> query to extract a list of names, and done a mysql_num_rows to determine[/color]
how[color=blue]
> many results I've gotten. I want to split the list in to two columns. I've
> created $percol = $mysql_num_rows/2 but I'm not quite sure how to "loop"
> through the first half of the list, echo </td><td> and then list the
> balance. Can anyone give me some guidance on how best to structure this?
>
> Thanx!
> Wm
>
>
>[/color]

You could use something like this:
..
..
$rowcount = 0;
while ($row=mysql_fetch_row($result))
$teller ++;
print "$row[0]<br>";
if ($rowcount >= $percol) {
print "</td><td>";
$rowcount = 0;
}
}

This way you can just as easy split your results over 3 or 4 columns, just
by changing $percol = $mysql_num_rows/$columns.


RP