array messing up

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, i don't know if this is the right list to post it, or php-general... I am posting here because i think its database related. so here we go: I want to build an array containing two arrays $navm[] and $navs[], $navs[] should go to $navm[items]. I am using an commercial db class to do my queries. This is the snippet making my array: - -sourcecode:start--------------------8<------------------------------ $resultm = $db->query("SELECT * FROM ".$p."_cats WHERE ms='m' \ ORDER BY sortorder ASC"); while($work_res_navm = $db->fetch_array($resultm)) { $results = $db->query("SELECT * FROM ".$p."_cats \ WHERE master='".$work_res_navm['catid']."' \ ORDER BY sortorder ASC"); while($work_res_navs = $db->fetch_array($results)) { $navs[]=array('link'=>$work_res_navs['link'], \ 'text'=> $work_res_navs['name'], \ 'id'=> $work_res_navs['catid'], \ 'master'=>$work_res_navs['master'] ); } $navm[] =array('link'=>$work_res_navm['link'], \ 'text'=> $work_res_navm['name'], \ 'id'=> $work_res_navm['catid'], \ 'items'=>$navs); }; - -sourcecode:stop---------------------8<------------------------------ table looks like this: - -table:start-------------------------8<------------------------------ CREATE TABLE ui_cats ( catid tinyint(11) NOT NULL auto_increment, ms char(1) NOT NULL default 's', master tinyint(1) NOT NULL default '1', sortorder tinyint(3) NOT NULL default '0', name varchar(150) NOT NULL default '', link varchar(150) NOT NULL default '', PRIMARY KEY (catid) ) TYPE=MyISAM AUTO_INCREMENT=8 ; - -table:stop--------------------------8<------------------------------ MySQL Version: 3.23.58 PHP-Version: 4.2.2 ( I can not update those versions..) the array now looks like this: $navm1-0 $navs1-1 $navs1-2 $navm2-0 $navs1-1 $navs1-2 $navs2-1 $navm3-0 $navs1-1 $navs1-2 $navs2-1 $navs3-1 and the same procedure a lot more often... but it should look like this: $navm1-0 $navs1-1 $navs1-2 $navm2-0 $navs2-1 $navm3-0 $navs3-1 and so on what is my error? i cant see it after trying several other querys in two days :-( any ideas? thanks in advice - -- - --------------------------------------------------------------------- Rainer 'Ny' Bendig | http://UnresolvedIssue.org | GPG-Key: 0xCC7EA575 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFBni4ltpAZoWtAN98RAi18AJ9ToJhWXlvJiVVE/GoH3ArHTYN/cACdHzU4 dU9lkx+M8UnVQPak/+ikQYs= =su6z -----END PGP SIGNATURE-----