Trying to print out array over multiple columns

TylerDurden

Hi, newbie PHP coder here. I'm doing a MySQL query that pulls data from a single table column and outputs it to a table. I want to be able to output it to two columns but have not yet been able to figure out a way to do it. Any help would be appreciated. Here's the code I currently have:

$result = mysql_query($sql);
print "<table>";
while ($row = mysql_fetch_row($result)) {
	print "<tr>";
	print "<td>$row[0]</td>";
	print "</tr>";
}

jeremuck

use one loop to loop through rows (tr) and get one result from the query
use a loop inside that one to do the columns and get each field from the result you got

The_Chancer

You might also need

while($row=mysql_fetch_array($result))

To make Jeremuck clearer (no offence meant)
Having <tr> </tr> inside your loop will make you have a new line every time the loop is run, whereas having <tr> LOOP HERE </tr> will only make one line in a table.

You may also want to automatically increment the number in your array, by using row[$i] instead, with $i++ at the end....

jeremuck

thanks, chancer, I was feeling lazy.
the question gets asked a lot.

The_Chancer

No worries....

Feeling too bright and breezy for nearly 5pm on a Friday... must be time to go home...!

Any more thoughts on my fu*king COM problem ? (sorry about swearing, but it is getting me down...)