construire une liste déroulante en cascade

http://articles.sitepoint.com/article/hierarchical-data-database

Il faut adapter cette fonction:

Code:

<?php
// $parent is the parent of the children we want to see
// $level is increased when we go deeper into the tree,
//        used to display a nice indented tree
function display_children($parent, $level) {
   // retrieve all children of $parent
   $result = mysql_query('SELECT title FROM tree '.
                          'WHERE parent="'.$parent.'";');

   // display each child
   while ($row = mysql_fetch_array($result)) {
       // indent and display the title of this child
       echo str_repeat('  ',$level).$row['title']."\n";

       // call this function again to display this
       // child's children
       display_children($row['title'], $level+1);
   }
}
?>

Pour ca remplisse les <option>

La ligne:

Code:

echo str_repeat('  ',$level).$row['title']."\n";

A remplacer par un truc du genre:

Code:

echo '<option value="'.$row['id'].'">'.str_repeat('--',$level).$row['title']."</option>\n";

Et ne pas oublier d'ajouter "id" dans la requête SELECT.