Hi there,
I currently have a dynamically built table, built with the following code -
$db = db_connect();
$query = "SELECT * FROM region where COUNTRY_ID=$country order by REGION_NAME";
$result = mysql_query($query,$db);
$num_results = mysql_num_rows($result);
for($i = 0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
$region_name = $row["REGION_NAME"];
$region_data .= "<tr><td>$region_name</td></tr>\n";
}
Due to having more data here than before I would like to be able to display the table across to columns but I don't know how.
I can do
a b
c d
e f
but not
a d
b e
c f
Please help. Thanks in advance
Nick
