Categories & Sub-Categories

[Kanundra]

I have two tables, one called Categories and one called SubCategories. Each subcategory needs to be displayed under its parent category in a HTML table.

 

So I have this code, but I don't know how to list each Sub-Category under each Category in a HTML table.

 

<?php

 

require ('includes/initialize.php');

 

require 'classes/database.class.php';

 

 

$sql = "SELECT * FROM Categories, SubCategories WHERE Categories.ID = SubCategories.CatID";

 

$Result = $database->Query($sql);

 

$Data = $database->Fetch($Result);

 

?>