Loop products by category

See more:

PHP

MySQL

Very new to PHP so please be patient.

I've got an SQL query that pulls products from a table and I need to display them in categories:

category 1
product 1
product 2
product 3
category 2
product 1
product 2
product 3

etc...

I've followed a few tutorials/posts but cant get the data displaying.

Thanks for any help.

So Far I have this:

<?PHP
$sql = "
    SELECT DISTINCT
        JVPCX.`category_id`,
        JVP.`product_id`,
        JVP.`product_sku`,
        JVP.`product_s_desc`
    FROM
        `jos_vm_product_category_xref` JVPCX
    INNER JOIN `jos_vm_product` JVP
        ON JVPCX.`product_id` = JVP.`product_id`
";
	
$res = mysql_query($sql);
$list = array();
while ( $r = mysql_fetch_object( $res ) )
{
    if ( ! isset( $list[ $r->category_id ] ) )
    {
        $list[ $r->category_id ] = array();
    }

    $list[ $r->category_id ][ $r->product_id ] = array(
        'SKU'     => $r->product_sku,
        'Description' => $r->product_s_desc,
		
	
    );
}
print_r($list);
var_dump($r);
?>

The output is:

Array ( [5] => Array ( [1] => Array ( [SKU] => EASY819-AC-RC [Description] => ) [3] => Array ( [SKU] => EASY819-DC-RC [Description] => ) [2] => Array ( [SKU] => EASY819-AC-RCX [Description] => ) ) [6] => Array ( [4] => Array ( [SKU] => EASY719-AB-RC [Description] => ) [5] => Array ( [SKU] => EASY719-AB-RCX [Description] => ) ) )

bool(false)

As I stated above I am trying to achieve:

category 1
product 1
product 2
product 3
category 2
product 1
product 2
product 3

Thanks for the advice.