Fetching related tables

[eluser]Jaketoolson[/eluser]
You could create the query and set the $vars in one loop, then run another loop to create the code.

Code:

$sql="SELECT id.c, id.name, title.p FROM Categories c
INNER JOIN Posts p ON p.category_id = c.id";
foreach ($query->result() as $row)
{
    $cat_id = $row->id;
    $post_title = $row->title;
    
    $datas[$cat_id][] = $post_title;
}

foreach ($datas as $key)
{
    echo '<div id="cat_'.key($key).'">';
    foreach ($key as $k => $v)
    {
        echo '<p>'.$v.'</p>';
    }
    echo '</div>';
}