Forms - ajax, php/mysql

[Iskib]

Maybe someone can help.

I am making a form to submit events. I want to let the user select a country and from the country a dropdown "select" opens with the eithier state (US) Prov (CA) or Region.

The countries are pulled form the database as are the states, provs, regions I want it to do this without reloading the page.

here is what I have so far top of the page I have:

<?php

$country = $state = null;

if(isset($_GET["country"]) && is_numeric($_GET["country"]))
{
$country = $_GET["country"];
}

if(isset($_GET["state"]) && is_numeric($_GET["state"]))
{
$state = $_GET["state"];
}

?>

<script language="JavaScript">

function autoSubmit()
{
var formObject = document.forms['events'];
formObject.submit();
}

</script>

Then have all the normal form fields (these are not the problem)
name of event
description of event
date/time of the event
City of the event (this is typed)

Then I have this for country and state/prov/region

<td><?php echo $lang['event_country'];?></td>
<td><select onChange="autoSubmit();" id="country" name="country" class="form_select" style="width:70%;">
<option value="null"></option>
<?php $fetch_countries = sql_query("SELECT * FROM countries");
while ($countries = mysql_fetch_array($fetch_countries)) {

echo ("<option value=\"$countries[country_id]\" " . ($country == $countries[country_id] ? "selected" : "") . ">$countries['country_name']</option>");

}

?>
</select></td>
</tr>
<tr>
<td><?php echo $lang['event_stateprov'];?></td>
<?php

if($country != null && is_numeric($country))
{

?>

<option value="null"></option>
<td><select name="stateprov" class="form_select" style="width:70%" onChange="autoSubmit();">
<option value="null"></option>
<?php

$fetch_stateprov = sql_query("SELECT state_id, state_name FROM states WHERE country_id = $country";

$statesprov = sql_query($fetch_stateprov);
while($stateprov = mysql_fetch_array($statesprov))

{
echo ("<option value=\"$stateprov[state_id]\" " . ($state == $stateprov["state_id"] ? "selected" : "") . ">$stateprov[state_name]</option>");
}

?>

</select>

<?php } ?>

Again I am learning php etc...

Do you see anything wrong with the code and what can I add to not reload the page and populate the second drop down

Thanks in advance!

--------------- Added 1194314774 at 1194314774 ---------------

I know i need to change the function , but I have no idea what to