Léa 1 - SQL 0

SELECT table_cat.categories_image,table_desc.categories_name,parent_cat_desc.categories_name FROM (SELECT *  from categories cat_fils
where EXISTS
(SELECT * FROM categories cat_par
WHERE cat_par.categories_id =cat_fils.parent_id)) table_cat,categories_description parent_cat_desc,
 categories_description table_desc  where table_cat.categories_id=table_desc.categories_id
            and table_desc.language_id=4 and table_desc.language_id=parent_cat_desc.language_id
            and table_cat.parent_id=parent_cat_desc.categories_id;

<!-- début menu déroulant dynamique -->
      <? // Je vais faire ma requete pour afficher les categories dans la liste déroulante
      $requete_menu_p = "SELECT * FROM categories,categories_description WHERE language_id=4 AND categories.categories_id=categories_description.categories_id AND parent_id=0 ORDER BY categories_name ASC";
      $resultat_menu_p = mysql_query($requete_menu_p);  ?><label>
      <select name="categories_id" id="categories_id">
     <? while ($ligne_menu_p = mysql_fetch_array($resultat_menu_p))
           { ?>
         <option value="<? echo $ligne_menu_p["categories_id"]; ?>" selected="selected">
         <?  echo $ligne_menu_p["categories_name"]; ?></option>         
         <? $requete_menu_s = "SELECT * FROM categories,categories_description WHERE language_id=4 AND categories.categories_id=categories_description.categories_id AND parent_id =".$ligne_menu_p["categories_id"]." ORDER BY categories_name ASC";
      $resultat_menu_s = mysql_query($requete_menu_s);
         while ($ligne_menu_s = mysql_fetch_array($resultat_menu_s))
            { ?>
            <option value="<? echo $ligne_menu_s["categories_id"]; ?>" selected="selected">
         ---><?  echo $ligne_menu_s["categories_name"]; ?></option>
            <? } ?>
           
         
         <? } ?>
      </select>
    </label>