Mixing results from 2 tables

[error_22]

Hi,

I have a db table called "catlinks". There are three different columns in there (c_id, c_name, c_url). I also have another table called "sublinks" with the columns: s_id, s_name, s_url, s_cat.

I want the values from these tables to show up like this:

[code]
<table>
<tr>
<td>Head links</td><td>Sublinks</td>
</tr>
<tr>
<td>headlink#1 (c_name)</td>sublink#1, sublink#2 (s_name with the c_cat value of c_id)</td>
</tr>
<tr>
<td>headlink#2 (c_name)</td>sublink#3, sublink#4 (s_name with the s_cat value of c_id)</td>
</tr>
etc...
</table>
[/code]

So I tried the following:

[code]
echo "<table>";
$sql = "SELECT * FROM catlinks l LEFT JOIN sublinks s ON c_id=s_cat ORDER BY c_name, s.s_name";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_object($result))
{
<tr>
<td><? echo $row->c_name; ?></td>
<td><? echo $row->s_name; ?></td>
</tr>
}
echo "</table>";
[/code]

The problem is, when I echo the results, I get this:

[img]http://www.octocomnetwork.com/result.png[/img]

Any help would be greatly appreciated!

Thanks in advance
Niklas

[error_22]

Anyone?