By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,747 Members | 2,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,747 IT Pros & Developers. It's quick & easy.

query results in 2 columns?

P: n/a
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

Jul 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Jul 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.