dynamic listboxes from mysql

[slevytam]

Hi everyone,

I am fighting with listboxes and was wondering if someone could give me a hand.

I have categories n levels deep. I would like to be able to populate the parent listbox from the database with all records level 1 deep. Then depending on the choice, populate a second listbox with subcategories at level 2 relating to the parent at level 1.

I know this is a bit complex; however, if someone can give me an example of dynamic listboxes that pull from a database I can work from there.

Thank you,

--SL

[tekky]

<?
echo '<select name=test>'; //start first list
while($row = mysql_fetch_assoc($result)) //loop through possible values
{
     echo "<option value='" .$row['option']. "'>" .$row['option']; //add each option
}
echo '</select>'; //close first list
if (isset($_POST['test'])) //if list had been selected before... build 2nd list
{
     $query = "SELECT * FROM ". $_POST['test']; //get 2nd list options
     $result = mysql_query($query);
     echo '<select name=' .$_POST['test']. '>'; //open 2nd list
     while($row=mysql_fetch_assoc($result))
     {
          echo "<option value='" .$row['option']. "'>" .$row['option']; //add 2nd list options
     }
     echo '</select>'; //close 2nd list
}
?>

that should be a 2 level example... note, this could be done better to make it infinetly possible... but that would take all the fun out of it if I wrote that 😉

note: this also assumes a table that is named "test" and tables named by the values of the test list, and then tables named after each option under test.... etc, in hindsite selecting 1 table WHERE list=$_POST['test'] would be better....

[slevytam]

Hello,

Thank you for your response. Appreciated.

I not sure if I made myself clear in the first post. I am looking to be able to do this without posting the page. ie using the onchange event of the listbox.

Thanks,

Shalom

[tekky]

in that case use the search button

this question was asked twice in the past 3 days if not more than twice