ASK PHP tolongin kk

[Braincode]

Quote:





echo '

• ';
  
  echo '
• Main Menu';
  
  
  
  while ($row = mysql_fetch_array($result)){
  
  extract ($row);
  
  echo '
• '.$row[category_name].'';
  
  
  
  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].'';
    
    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].'';
      
      }
      
      
      
      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