I dont understand how to achieve this...

[error_22]

Hi,

I have a db table called "links". There are three different columns in there (l_id, l_name, l_url). I also have another table called "sublinks" with the columns: s_id, s_name, s_url, s_head.

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


<table>
<tr>
<td>Head links</td><td>Sublinks</td>
</tr>
<tr>
<td>headlink#1 (l_name)</td>sublink#1, sublink#2 (s_name with the s_head value of l_name)</td>
</tr>
<tr>
<td>headlink#2 (l_name)</td>sublink#3, sublink#4 (s_name with the s_head value of l_name)</td>
</tr>
etc...
</table>


For some reason, I cant understand how to achieve this? Could anyone possibly help me out here? Any help is much appreciated!

Thanks in advance
Niklas

[error_22]

Anyone?