//javascript
Expand|Select|Wrap|Line Numbers
- <script language="JavaScript">
- function autoSubmit()
- {
- var formObject = document.forms['theForm'];
- formObject.submit();
- }
- </script>
[PHP]
$province = $site = null; //declare vars
if(isset($_GET["province"]))
{
$province = $_GET["province"];
}
if(isset($_GET["site"]) && is_numeric($_GET["site"]))
{
$city = $_GET["site"];
}
<form name="theForm" method="get">
<select name="province" onChange="autoSubmit();">
<option value="null">Province</option>
<?php
//POPULATE DROP DOWN MENU WITH PROVINCES
$sql = "SELECT DISTINCT Province FROM SAMP_SITE";
$provinces = mysql_query($sql);
while($row = mysql_fetch_array($provinces))
{
echo ("<option value=\"$row[Province]\" " . ($province == $row["Province"] ? " selected" : "") . ">$row[Province]</option>");
}
?>
</select>
<br><br>
<?php
if($province != null)
{
?>
<select name="site"">
<option value="null"></option>
<?php
//POPULATE DROP DOWN MENU WITH SITES GIVEN SELECTED PROVINCE
$sql = "SELECT SiteName,SAMP_SITE_ID FROM SAMP_SITE WHERE Province = '$province' ";
$sites = mysql_query($sql);
while($row = mysql_fetch_array($sites))
{
echo ("<option value=\"$row[SAMP_SITE_ID]\" " . ($city == $row["SAMP_SITE_ID"] ? " selected" : "") . ">$row[SiteName]</option>");
}
?>
</select>
<?php
}
?>
<input type='image' src='searchedirt.bmp' onClick='submit'>
</form>[/PHP]