combo box with data from table in database

[zhahaman2001]

ok along with my other problem im trying to do something else...

lets say i have 2 tables in my database one is named states and one is named citys
and lets say on my page i have a 2 combo boxs like this:

[code]
print "<select name='stateid'>";
$TEMP = mysql_query("select * from states order by name");
while ($state = mysql_fetch_array($TEMP)) {
      print "<option value='$state[id]'>$stat[name]</option>";
}
print "</select>";

print "<select name='city'>";
      // Here my problem
print "</select>";
[/code]

i want it so when i click one of the states from the first combo box that it goes to the cities table of my database and fills the 2nd combo box with all the citys that are in that state

[zhahaman2001]

did i post this in the wrong section or......did i write it in a way that no one understands? i really need this problem solved please anyone have any ideas?? please!!!!!

[Jessica]

You'll need to use ajax.

[zhahaman2001]

any links where i can get an idea of how to do it?

[Jessica]

check out mootools.net and the ajax forum here.