Tema: Re: Php array :)
Autorius: gopas
Data: 2010-03-26 08:29:22
tai kad pas tave masyve $tree_data visada bus trys reiksmes ir nieko daugiau.
$tree_data['url'] = 'www.google.lt';  $tree_data['parent'] = $row['catname'];  $tree_data['name'] = $row2['subname'];

as meniu tau siulyciau daryt taip:
pasidaryt mysql lentele. joje
id | parent_id | title

auksciausiam lygi parent_id = 0, zemesniam parent_id tevinio meniu punkto id.
nu ir tada spausdini....
$q = 'SELECT * FROM `menu` WHERE `parent_id` = 0';
$res = mysql_query(...);
while ($data = mysql_fetch_assoc($res)) {
    echo $data['title'].'<br>';
    $q = 'SELECT * FROM `meny` WHERE `parent_id` = '.$data['id'];
    $res2 = mysql_query(...);
    while ($data2 = mysql_fetch_assoc($res2)) {
        echo '-----------'.$data2['title'].'<br>';
    }
}

mazdaug taip...zinoma jei gerai supratau ko tau reikia :) jei meniu daugiau lygiu, tai geriau pritaikyt rekursija.

"exoticdevil" <born4devil@gmail.com> wrote in message news:hogld4$b92$1@trimpas.omnitel.net...
> niekaip array nesusidelioju...
> darau meniu cia:) bet niekaip nesudedu visko i viena array'u. Yra dvi 
> lenteles mysql, categories ir sub_cat. Ir ta ir ta reik i tapati array 
> padeti, tik dedant subcategorija reikia i 'parent' dateti categorijos name. 
> Jai i array dedu category, parent = '0'; Ta visa array apdoroja scriptas, 
> jis veikia normaliai kai suvesdavau rankom reiksmias, bet dabar kazko 
> klaidas meta, jau galva nebesisuka, tai gal kas pagelbesit :) Aciu labai.
> 
> 
> include('admin/sqlcon.php');
> $tree_data = array();
> $query = " SELECT * FROM categories";
> $result = mysql_query($query) or die('Error, query failed');
> while($row = mysql_fetch_array($result))
> {
> 
> $tree_data['url'] = 'www.google.lt';
> $tree_data['parent'] = '0';
> $tree_data['name'] = $row['catname'];
> 
>    $query2 = " SELECT * FROM sub_cat";
>    $result2 = mysql_query($query) or die('Error, query failed');
>    while($row2 = mysql_fetch_array($result))
>    {
>        $tree_data['url'] = 'www.google.lt';
>        $tree_data['parent'] = $row['catname'];
>        $tree_data['name'] = $row2['subname'];
>    }
> } 
>
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser