malutki kłopot z tablicami Opcje

[acztery]

witam...

mam coś takiego...

[PHP] pobierz, plaintext 
<?php
public function getCatOnlyPub($_id)
	{
			$categ = DB_DataObject::factory('sys_cats');
			$categ->selectAdd();
			$categ->selectAdd('CatID,CatName,CatParentID,patch');
			$categ->whereAdd("CatParentID='$_id'");
			$categ->find();
 
			while($categ->fetch()) 
			{
				$RET[] = $categ->toArray();
 
 
			} 
			return $RET;
	}
?>
[PHP] pobierz, plaintext 

to wyśwetla mi wszystkie kategorie , nazwy, rodzicow itp danej kategori ktora przekazujemy w parametrze


wyglada to tak np:

[HTML] pobierz, plaintext 
Array
(
    [0] => Array
        (
            [CatID] => c_ivip5y
            [CatName] => P?(IMG:http://forum.php.pl/style_emoticons/default/questionmark.gif) ??yty winylowe
            [CatParentID] => c_ivip2g
            [patch] => Aukcje.c_ivip2g
            [CatLang] => 
            [CatIconID] => 
            [CatIconFile] => 
            [CatCreateDate] => 
            [CatAdult] => 
            [imgrek] => 
        )
 
    [1] => Array
        (
            [CatID] => c_ivip6j
            [CatName] => Instrumenty
            [CatParentID] => c_ivip2g
            [patch] => Aukcje.c_ivip2g
            [CatLang] => 
            [CatIconID] => 
            [CatIconFile] => 
            [CatCreateDate] => 
            [CatAdult] => 
            [imgrek] => 
        )
 
    [2] => Array
        (
            [CatID] => c_ivip6o
            [CatName] => Gry towarzyskie
            [CatParentID] => c_ivip2g
            [patch] => Aukcje.c_ivip2g
            [CatLang] => 
            [CatIconID] => 
            [CatIconFile] => 
            [CatCreateDate] => 
            [CatAdult] => 
            [imgrek] => 
        )
)
[HTML] pobierz, plaintext 

i jak chce zeby dodatkowo wyswetlil mi tez wszystkie tytuly, i nazwe kategori mojacych id pobrane z [CatParentID]


mam nadzieje ze nie namieszalem

[NuLL]

Musisz dodac prostego JOINA SQLowego (IMG:http://forum.php.pl/style_emoticons/default/tiredsmiley.gif) Wiecej w manualu MySQLa (IMG:http://forum.php.pl/style_emoticons/default/smile.gif)