Archief - PHP: JOIN of niet ?

+----+-----------+
| id | name      |
+----+-----------+
|  1 | Webdesign |
|  2 | Games     |
|  3 | Friends   |
+----+-----------+

+----+-----+-----------+------+------+
| id | cid | name      | info | link |
+----+-----+-----------+------+------+
|  1 |   3 | naam1     | .... | .... |
|  2 |   1 | naam2     | .... | .... |
|  3 |   2 | naam3     | .... | .... |
|  4 |   1 | naam4     | .... | .... |
|  5 |   2 | naam5     | .... | .... |
+----+-----+-----------+------+------+

$query = mysql_query("SELECT * FROM links_cat ORDER BY name ASC");
if (mysql_num_rows($query)) {
  while ($list = mysql_fetch_object($query)) {
    echo $list->name;
    $query1 = mysql_query("SELECT * FROM links WHERE cid='$list->id' ORDER BY name ASC");
    if (mysql_num_rows($query1)) {
      while ($list = mysql_fetch_object($query1)) {
        echo "<a href=\"".$list->link."\" onclick=\"window.open(this.href,'_blank');return false;\">".$list->name."</a> - ".$list->info."<br />";
      }
    } else {
      echo "No links in this category posted yet.";
    }
  }
} else {
  echo "No categories posted yet.";
}

$sql = "SELECT lc.name AS cat, l.name, l.info, l.link FROM links_cat lc LEFT OUTER JOIN links l ON (lc.cid = l.id) ORDER BY lc.name, l.name ASC";
$result = mysql_query($sql);

// reset vars
$cat = "";

// weergave opbouwen
while ($row = mysql_fetch_array($result))
	{
	if ($cat != $row['cat'])
		{
		// als de cat niet dezelfde is als de vorige een nieuwe titel weergeven
		$cat = $row['cat'];
		echo "<br />categorie: ".$cat."<br />";
		}
	// checken of er wel links zijn
	if ($row['name']==NULL)
		{
		echo "Geen links in deze categorie";
		}
	else
		{
		echo "- <a href=\"".$row['link']."\" target=\"_blank">\".$row['name']."</a>&nbsp;".$row['info']."<br />";
		}
	}