Formating Query Results

[Anon]

Someone please help me with this! I have a project that I am working on can I need to know how to format query results into 2 table columns. Here is the code I have now:

<?php
include ('_includes/common.inc');
$conn = mysql_connect($dbhost,$dbusername,$dbpassword);
mysql_select_db($dbname, $conn);
$result = mysql_query("SELECT id, category FROM business_categories ORDER BY category ASC", $conn);
?>
<?php while($query_data = mysql_fetch_array($result)) { ?>
<a href="business_list.php?category=<?php echo $query_data[id] ?>"><?php echo $query_data[category]; ?></a><br>

<?php }; ?>

I will be forever grateful to someone that can help me with this.

Thank you in advance!!!

[Anon]

If I understand you correctly, you want something to display the links in two columns. Try this ...

echo "<table><tr>";
while($query_data = mysql_fetch_array($result)) {
echo "<td><a href='business_list.php?category=$query_data[id]'>";
echo $query_data[category];
echo "</a></td>";
$i++;
if ($i == "2") {
echo "</tr><tr>";
$i = 0;
}
}
echo "</tr><table>";

You will probably want to include some logic to check if you have an even number of links, as browsers differ in the way they handle table cells that don't exist.

[Anon]

Thank you so much! I got it working with little modification! You are the man.