[Resolved] Dynamic SELECT

[NoBullMan]

Hi,
I have a form with 3 drop downs.
I have populated the first drop down with entries of a table in a database (MySQL Database). I need to populate the second drop down based on what was selected in the first one and I don't know how (ditto for the third drop down, based on the selection from the second drop down.)
I know how to do it in javascript but I need to get the values from the database tables.
The values of the form will be passed to another php page upon submission.

I really appreciate your help.

<select name="Builder">
<?php $b_array = get_builders();
if (!is_array($b_array)){
echo 'No builders currently available';
return;
}
foreach ($b_array as $row){
echo '<option value="';
echo $row['builderid'];
echo '">';
echo $row['name'];
echo "</option>\n";
}

?>
</select>
(function get_builders() returns an array of rows of the table called "builders")

[swr]

You need to use javascript for this.

In order to get the info out of the database and in to javascript, you need some PHP that will get the information and spit out a javascript array.

So you'd have something like this:

$things = array();
$result = mysql_query("select whatever from things") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
   $things[] = $row[0];
}
echo "jsarray = [ ".implode(",", $things)." ];\n";

That will spit out a javascript array that you can then use in your javascript on the page. You'll need to modify it for whatever you're doing of course, but that should get you started.

[Weedpacket]

You might like to consider using Javascript and PHP together in the manner suggested here.

But you will need some Javascript.