Menu Model

[eluser]Think Floyd[/eluser]
That's most generous.

I've written the code in a "scripting" style, but I'm really trying learn a framework and Design Pattern in the vein attempt to encapsulate and modularise my code.

DB structure:

TABLE: category
id
title

TABLE : subcategory
id
title

JOIN TABLE: categories_subcategories
category_id
subcategory_id

Code:

$sql = "Select * From categories ORDER BY title";
$res = mysql_query ( $sql );

// Category Links
echo "<ul id='catmenu' class='catmenu'>";
While ( $row = mysql_fetch_array ( $res ) )
{    
    $sql_sub = "Select sc.* From (subcategories sc, categories_subcategories csc) ";    
    $sql_sub .= "WHERE csc.subcategory_id = sc.id ";    
    $sql_sub .= "AND csc.category_id = " . $row ['id'] . " ";    
    $sql_sub .= "ORDER BY sc.title";    
    $res_sub = mysql_query ( $sql_sub );
            
    echo "<li><a href='" . $url_path . "/category/index.php?cat=" . $row ['><span>" . $row ['title'] . "</span></a>";
    echo "<ul>";
        
    // Sub Category Links
    if (mysql_num_rows ( $res_sub ))
    {
        While ( $row_sub = mysql_fetch_array ( $res_sub ) )
        {
        
            echo "<li><a href='" . $url_path . "/category/index.php?cat=" . $row ['sub=" . $row_sub ['id'] . "><span>" . $row_sub ['title'] . "</span></a>";
        }
    }
    echo "</ul>";
    echo "</li>";
}
echo "</ul>";