query results in 2 columns?

[Wm]

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

[RP]

"Wm" <LA*******@hotmail.com> schreef in bericht
news:xM*****************@news.easynews.com...

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

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