Hello,
I am very new to php and mysql so please be patient with me. I don't even
know if I am using the right listing, but I hope someone can help me!
I need to create a <select> and the possible options are from my mysql
database ( so far so good, I was able to find code to do that).
Now I need to use the user selected option to drive the options of me next
<select>. I need to know how to capture what user selected and how to pass
that around? I have used "onchange" attribute of the <select> to capture the
selected line but now how can I pass that to other php scripts? ( I need to
get the name of the country so that I can show a list of possible
state/province. I setting the value of the "newcountry" input to the
selected "country" but when I do echo $newcountry in quicksearch.php, its
blank!!)
Please help!!
Thanks so much
Here is what I have so far:
Quicksearch.php file has the following code
<br>
<table class='form'>
<tr>
<th>Steps 1-4</th>
</tr>
<tr><td>
<form name="fcountry" method="post">
<?php require("country_build.php");?>
<input type="text" name="newcountry" value="">
</form>
</td></tr>
</table>
<!-- quicksearch.php end -->
<script language="JavaScript">
<!--
function changeMenu()
{
document.fcountry.newcountry.value =
document.fcountry.country.options[document.fcountry.country.selectedIndex].v
alue;
}
-->
</script>
Countrty_buil.php has the following
<?php
require_once("util.php");
echo "<SELECT name=\"country\" class=\"input\" onchange=\"changeMenu()\">";
//
// initialize or capture the country variable
$country = !isset($_REQUEST['country'])? "Select a country":
$_REQUEST['country'];
$countrySQL = !isset($_REQUEST['country'])? "*": $_REQUEST['country'];
echo "<option value='$countrySQL' SELECTED>$country</option>";
$query = "SELECT country FROM ". TABLECOUNTRY . " ORDER BY country ASC";
// pconnect, select and query
if ($link_identifier = mysql_pconnect(DBSERVERHOST, DBUSERNAME, DBPASSWORD))
{
if ( mysql_select_db(DBNAME, $link_identifier)) {
// run the query
$queryResultHandle = mysql_query($query, $link_identifier) or die(
mysql_error() );
$ctrRows = mysql_num_rows($queryResultHandle); // row counter
// if data exists then $rows will be 1 or greater
if( $ctrRows == 0 ) {
echo"<option value='*'>No data found</option></select>";
}else{
// build the select list
while($row = mysql_fetch_object($queryResultHandle)) { //
grab a row
echo "<option
value=\"$row->country\">$row->country</option>";
}
echo "</SELECT><br><br>";
}
}else{ // select
echo mysql_error();
}
}else{ //pconnect
echo mysql_error();
}
?>
