Problema con DB e ciclo while annidato

[bstefano79]

sovrascrivi il result
fai così

$query = "SELECT cat_id, cat_parent_id, cat_name  
                     FROM tbl_category  
                     WHERE cat_parent_id = 0";  
$result = dbQuery($query);  
  while($row = dbFetchAssoc($result)) {  
    extract($row);  

echo"[*]<a href=\"#\">".$cat_name."</a><ul>";  

$query_cat = "SELECT cat_id, cat_parent_id, cat_name  
                    FROM tbl_category  
                    WHERE cat_parent_id = $cat_id ORDER BY cat_name ASC";  
$result1 = dbQuery($query_cat);  
   while($row1 = dbFetchAssoc($result1)) {  
     extract($row1);  

echo"<li class=\"sub\"><a href=\"prodotti.php?c=".$cat_id."\">".$cat_name."</a>";  
}  
echo"[/list]";  
}  
echo"";