rendered paste body <?php $result = mysql_query('SELECT * FROM categories LEFT JOIN sub_categories ON categories.id = sub_categories.category_id'); while($category = mysql_fetch_assoc($result)) { if ($category['sub_id'] != 0) { echo '<a id="bold" href="index.php?p=shop&cat='. $category['id'] .'">'. $category['name'] .'</a> <br /> <a href="index.php?p=shop&cat='. $category['id'] .'&sub='. $category['sub_id'] .'">'. $category['sub_name'] .'</a> <br /><br />'; } else { } ?>