ASK PHP tolongin kk

[Braincode]

Quote:





echo '

';

echo '
Main Menu (http://www.ceriwis.org/index.php)';



while ($row = mysql_fetch_array($result)){

extract ($row);

echo '
'.$row[category_name].' (http://www.ceriwis.org/sub_category.php?category='.$row[id_category].')';



echo '
';

$query2 ='select * from sub_category where category_id='.$row[id_category];

$hasil =mysql_query($query2,$db)or die(mysql_error($db));

while ($r = mysql_fetch_array ($hasil)){

extract ($r);

echo '
'.$r[sub_category_name].' (http://www.ceriwis.org/sub_products.php?sub_category='.$r[id_sub_category].')';

echo'
';

$query2 ='select * from product where sub_category_id='.$r[id_sub_category];

$hasil =mysql_query($query2,$db)or die(mysql_error($db));

while ($r = mysql_fetch_array ($hasil)){



echo'
'.$r[product_name].' (http://www.ceriwis.org/#)';

}



echo'
';







}

echo'
';



}



?>












kk saya mau menampilkan menu dengan 3 level ,

ex:

category1 --> sub_category1 --> product1

category2





tapi untuk tiap tabel cuma keluar 1 data , masalahnya dimana yah kk , karena kalau 2 level , tanpa product gk ada masalah ,



mohon bantuanya

</div>