Dynamic Drop Down

[Anon]

Hello there:

I have two Drop down controls, in one the user choose a city after that the second control fills its information using that city. I am using mysql database where i have that information. I have found several scripts using Javascript for fill two drop down, such script uses static information they asume the same number of items, the problem is that each time the user selects one city the second drop down fills with its info, so i have to use php each time the user clicks... can someone help me please ??? thanks in advance

[Anon]

how about....

//mysql connections stuff goes here

print ("<form method='$PHP_SELF'>");
print ("<select name='city'>");

$sql = mysql_query(Select...blah blah);
while($row = mysql_fetch_row($sql))
{
$cities = $row[0];

print ("<option>$cities</option>");
}
print ("</select></form>");

//second pulldown
if($city)
{
print ("<form method='$PHP_SELF'>");
print ("<select name='city'>");

$sql = mysql_query("SELECT FROM $table WHERE whatever='$cities'");
while($row = mysql_fetch_row($sql))
{
$variable = $row[0];

print ("<option>$variable</option>");
}
print ("</select></form>");
}

else
{
print ("<form><select>whatever you want here</select></form>");
}

or along these lines anyway....?

rgds,
scott d~

[Anon]

what you want to do is use the php to echo javascript to the page, creating an array indexed by city, each element of which is an array of whatever the other options are that you want.

then, remembering that the options[] property of the select object is read/write, set up an onchange handler for the first dropdown that erases the options[] of the second, and writes inthe appropriate array.

(while i know this isn't a javascript forum, i think that the interaction between javascript and php is one of the the most powerful tools available to us, so i think that this is a valid on-topic response)

--
rad