Nexted Loop Help Newbie Help....

[carbonxps]

I'm struggling to get any output from 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,

    );
}
?>

 

I am trying to get the following:

 

Cat1

    Product1

    Product2

Cat2

    Product3

    Product4

 

etc etc.

 

Any help would be great... Thanks in advance.

[batwimp]

Is it outputting anything?

[carbonxps]

No nothing at all...

 

I tried:

'SKU'    => $r['product_sku'],

'Description' => $r['product_s_desc]',

 

But it was giving a sytax error... Thanks so much for your help. I've been trying this all day...

Is it outputting anything?

 

[batwimp]

have you tried a var_dump($r) to make sure your database is being queried correctly?

[KevinM1]

What's the error message you're getting?

[carbonxps]

OK so looks like it might not be getting data:

 

have you tried a var_dump($r) to make sure your database is being queried correctly?

 

 

bool(false) Wierd it works fine on the database directly. 

 

No Errors at all.

[batwimp]

Try a print_r($list) after your while loop. Anything?

[carbonxps]

Try a print_r($list) after your while loop. Anything?

 

OK so it is getting data:

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] => ) ) )

 

 

[carbonxps]

Can anybody help getting this

 

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] => ) ) )

 

to output like this:

 

Cat1

    Product1

    Product2

Cat2

    Product3

    Product4

 

I've

[DavidAM]

You will have to loop through the categories and products. Something like the code below.

 

foreach ($list as $catID => $products) {
  print($catID);
  foreach ($products as $prodID => $data) {
    print($prodID . ': ' . $data['SKU'] . ': ' . $data['Description']);
  }
}

 

I didn't put any formatting in there, you should be able to handle that.

[carbonxps]

You will have to loop through the categories and products. Something like the code below.

 

foreach ($list as $catID => $products) {
  print($catID);
  foreach ($products as $prodID => $data) {
    print($prodID . ': ' . $data['SKU'] . ': ' . $data['Description']);
  }
}

 

I didn't put any formatting in there, you should be able to handle that.

 

Thanks very much for all your help.... hope I can return the good some day.