HTML tables: vertical NOT horizontal

Anon

getting a result from a query, and displaying them in an HTML table from left to right is fine, but what about doing it vertically?

For example:

A B
C D
E F

Results shown left to right. this is not very desirable from an ergonomic aspect, as a user would normally read top to bottom on the first column then top to bottom on the next, as follows;

A D
B E
C F

Does anyone know of the way to do this? Get the result array, if an odd number, round up, divide by two and thats as far as i get....

cheers
oli

toma42

Like I do here?
http://db.etree.org/shncirc/

I take the total rows and divide by num of columns (3) then loop through the rows and echo a </td><td> when I\'m 1/3 done.

To get better layout control put a new table inside the cells.

Anon

on code?

Anon

Take your example and put the index of the array in each cell, and you'll find a pattern. Tom already gave you the hints on the mathematics involved.

Diego

Anon

$count_rows = mysql_query("SELECT * FROM maincategory ORDER BY mainName");
$numrows = mysql_num_rows($count_rows);
?>

<?php
$count = 0;
$divide = 2;
$limit = ceil($numrows/$divide);

$result2 = mysql_query("SELECT * FROM maincategory ORDER BY mainName LIMIT $count,$limit");
	while ( $row = mysql_fetch_array($result2) ) 
	{
		$cid = $row["id"];
		$cname = $row["mainName"];
			echo ("\n<table width=\"100%\" border=\"0\"><tr>");
			echo ("<td><div align=\"center\"><a href=\"?action=subcats&mainID=$cid\">$cname</a></div></td>"); 
			echo ("</tr></table>\n");
	}

	echo ("</td><td>");

$result3 = mysql_query("SELECT * FROM maincategory ORDER BY mainName LIMIT $limit,$numrows");
	while ( $row2 = mysql_fetch_array($result3) ) 
	{
		$cid2 = $row2["id"];
		$cname2 = $row2["mainName"];
			echo ("\n<table width=\"100%\" border=\"0\"><tr>");
			echo ("<td><div align=\"center\"><a href=\"?action=subcats&mainID=$cid2\">$cname2</a></div></td>"); 
			echo ("</tr></table>\n");
	}

?>
</td>
</tr>
</table>