DB Results

[Anon]

Please help, I'm stuck here. I've been trying to get this query result to echo in a table.

EX:

+---------------+--------------+
|Catagory 1 |_____________ |
+---------------+--------------+
|sub-catagory A |sub-catagory B|
+---------------+--------------+
|sub-catagory C |sub-catagory D|
+---------------+--------------+
|sub-catagory E |sub-catagory F|
+---------------+--------------+

<table>
<tr>
<td>
<h1>CATAGORY 1</h1>
</td>
</tr>

<?php
$sql = "SELECT ID, Name FROM table_name ORDER BY Name";
$query = mysql_query($sql)or die("Couldn't Query SQL Server for Cuisine");
while ($row = mysql_fetch_array($query)) {
$cID = $row["ID"];
$cName = $row["Name"];

I know I need a statement here, but I'm at a loss!!

echo ("<a href=\"result.php?cID=$cID\">$cName</a><br>\n");
}
?>

</table>

Thank You In Advanced,
SP

[Anon]

I think that just using a counter should do, because what you want is to print every 2 results in the same row, so something like:
(untested code)

<table>
<tr>
<th colspan=2>CATEGORIES</th>
</tr>
<tr>
<?php
// your connection and query code here

$nrows = mysql_num_rows($result);
$pad_last_row = ( ($nrows % 2) == 0 );
$c = 1;
while ($row = mysql_fetch_array($query)) {
$cID = $row["ID"];
$cName = $row["Name"];
if ($c == $nrows) {
echo '<td colspan=2>'
} else {
echo '<td>';
}
echo '<a href="result.php?cID='.$cID.'">'.$cName.'</a></td>\n';
if (($c % 2) == 0 ) {
echo "</tr>\n<tr>";
}
$c++;
}
?>
</tr>
</table>
}