sorting mysql results in html tables

blue928

Hi, i am pulling results from a my mysql database using a WHILE() loop. there are a lot of results, however. I want to be able to keep these results above the fold using tables. so, my question is, how do I get mysql and php to put these results into horizontal html tables? ie, stop results 1-10 in left column and 11-20 in the next cell?

example:
instead of:
cars
dogs
cats
birds
carrots
apples

I want to:
cars carrots
dogs apples
birds

any suggestions?

thx
blue

blue928

er, table correction.. here is a better representation of what i need to achieve in my while loop:

-cell1-----cell2---------------------
+ dogs + cats +
+ carrots + apples +
+ peas + +

+ stuff + +

finger

first you add an ORDER BY-clause to your
SELECT-Statement.
pseudo-code:

i=0

while (row = fetch)
{
if ((i % 10) == 0)
print </tr><tr>

print <td>
print data
print </td>

i++
}

something like tis should work ...

hope that helps

finger

seand

I am lost on this issue as well. I need to extract data from a query (no problem) but displaying it in a tidy format with rows and columns is mind blowing as I am a newbie. If you have had any success please let me know, thank would be great, thanks.

Anon

<?php
$sql = ("SELECT tablerow1, tablerow2 FROM table");
$query = mysql_query($sql);

echo "<table border=1><tr>";
$count = 1;
$numcols = 4;
while ($row = mysql_fetch_array($query)) {
	$cid = $row["tablerow1"];
	$cname = $row["tablerow2"];
    print "<td>$cname</td>";
    print (is_int($count/$numcols)) ? "</tr><tr>" : "";
    $count++;
    }