php and mysql help

[irkevin]

Hello

 

I'm having a little problem, where I'm selecting categories from mysql, along with it's subcategories. The problem is, whenever there are multliple SUBcat for a category, it keeps repeating the category name.

 

Here an example of what's happening:

 

Array
(
    [0] => stdClass Object
        (
            [cat_name] => computers
            [sub_name] => Mouse
        )

    [1] => stdClass Object
        (
            [cat_name] => computers
            [sub_name] => Keyboard
        )
)

 

I would prefer it to be like so:

 

Array
(
    [0] => stdClass Object
        (
            [cat_name] => computers
            [sub_name] => Mouse
            [sub_name] => Keyboard
        )
)

 

The mysql query is like so

 

		
$query = "SELECT category.cat_name,sub_cat.sub_name FROM sub_cat
	LEFT OUTER JOIN category ON sub_cat.cat_id = category.id";

 

Table category has those fields

 

CATEGORY

id

cat_name

 

SUB_CAT

id

cat_id

sub_name

 

Can someone please explain how to achieve this? I'm stuck :S Thank you

[taquitosensei]

this is your mysql loop
{
         $categories[$row['categoryname']][]=$row['cubcaegoryname']; 
}

[irkevin]

Phhheeeww thanks sensei sama XD

[irkevin]

I know this is solved,

 

but suppose i will like to pass in the ID also, how do i alter this ?

[taquitosensei]

this is your mysql loop
{
         $categories[$row['categoryid']][]=array("subcategoryname"=>$row['sub_name'],"categoryid"=>$row['categoryid']); 
}

then

foreach($categories as $categoryname=>$category)
{
$categoryid=$category['categoryid']; 
$subcategory=$category['categoryname']; 
}