php & mysql query

[dave123]

<select name="state" onChange="getCity(this.value);">
<option>Select State</option>
<? while($row=mysql_fetch_array($result)) { ?>
<option value="<?php echo $row[0] ?>"><?=$row[2]?></option>
<? } ?>
</select>

function getCity(stateID)
call strURL="/findCity.php?state="+stateId;

findCity.php has the following:
$stateId=intval($_GET['state']);
$stateID is empty here. why?
$query="SELECT FROM cities WHERE SID='$stateID'"; << this is what I want to run. but
$query="SELECT FROM cities WHERE SID=4";
works.

what&where is the error?

[nemonoman]

dave123;10921263 wrote:

$stateId=intval($_GET['state']);
$stateID is empty here. why?

$stateId is NOT $stateID (note capital D) PHP is cApS SeNsiTive

[dave123]

this is typo I made here. I have $stateId correctly on file.

[nemonoman]

May I suggest you post the actual code causing the problem? May I suggest that saying "the typo isn't the problem - the real code doesn't have that typo' is not very reassuring about your ability to scrutinize your code for problems. Also showing us code that isn't causing the problem isn't getting us any closer to your actual problem.

[dave123]

<script>
function getState(countrId)
{
$countryId=parseInt(countrId);
alert($countryId+4);
var elSel = document.getElementById('locState');
var val=1;
var tex="fdsa";
var option = new Option(tex, val);
elSel[elSel.length]=option;
<?php
$query="SELECT * FROM states WHERE CID=2";
$result=mysql_query($query);
while($s=mysql_fetch_array($result))
{ ?>
tex ="<?php echo $s[2]; ?>";
val ="<?php echo $s[0]; ?>";
option = new Option(tex, val);
elSel[elSel.length] = option;
<?php } ?>
}
</script>

i rewritten the code. the same problem exist here also. the problem is that if I change the 2 to '$countryId' nothing happens.
$query="SELECT * FROM states WHERE CID='$countryId'"; <<< this what I want to run.

[nemonoman]

$countryId=parseInt(countrId);

This is in your javascript. The value isn't passed into PHP.

IF you look at the javascript code output, you'll see something like:

$countryId=parseInt(countrID);

so your JAVASCRIPT has a variable called $countryId -- but PHP doesn't know about it.

If $countryId is floating around as some sort of query variable, either from a url ($GET) or form ($POST) you're going to have get it into the <? PHP ?> like this:

$query="SELECT * FROM states WHERE CID=".$_REQUEST['countryId'];

[dave123]

<form name="event" id="event" method="post" action="<?php echo SearchAction;?>" onsubmit="return chkFrm();">

<fieldset>
<legend>Country:</legend>
<div class="frmOpt">
<label >Country:</label>
<select name="country" id="country" onChange="getState(this.value);">
<?php
$que = "select * from countries";
$countries = doQuery($que);
while($val1 = mysql_fetch_row($countries)){
?>
<option value="<?php echo $val1[0]; ?>"><?php echo $val1[1]; ?></option>
<?php //end if
}//end foreach ?>
</select>
</div>
</fieldset>

How do I pass the selected country to getState()?

[nemonoman]

From this:
<select name="country"

The variable floating around is named 'country' and can be found in the Global variables "$REQUEST" or "$POST".

These are arrays, so find the proper element of the array:
$REQUEST['country'] or $POST['country']

so

$query="SELECT * FROM states WHERE CID=".$_POST['country'];

or

$countryId=$_POST['country'];
$query="SELECT * FROM states WHERE CID=$countryId";

[dave123]

nemonoman;10921421 wrote:

From this:
<select name="country"

The variable floating around is named 'country' and can be found in the Global variables "$REQUEST" or "$POST".

These are arrays, so find the proper element of the array:
$REQUEST['country'] or $POST['country']

so

$query="SELECT * FROM states WHERE CID=".$_POST['country'];

or

$countryId=$_POST['country'];
$query="SELECT * FROM states WHERE CID=$countryId";

$_POST['country'] is select box. isn't it? how do we get the selected value?

[dave123]

neither of them working.

[nemonoman]

OK. I'm an idiot and you're sort of a newbie:

You're not going to get a list of states from a javascript function unless you have filled the javascript function with a way to access potential list of states. Which from all appearances, you haven't.

You can't get a $variable to the database to perform a query unless you submit the form (or have some sort of AJAX program working).

You really need to start by reading a basic primer on PHP. You're out of your depth at the moment.

[dave123]

what about creating $countryId at the top of the file in
<? $countryId=0;?>
then
<select name="country" id="country" onChange="getState($countryId=this.value);">

or

<select name="country" id="country" onChange="$countryId=this.value;getState();">

[nemonoman]

I'm sorry to say that you are so misguided in what you think you are doing. Where did you come across this sort of scripting? You need to find a tutorial, work on it a little bit, and then come back. This is sort of PHP 101, and you'd be doing the stuff you're trying to do by midterms. Right now, you're walking in to the middle of the movie, and you're having trouble understanding the plot.

[dave123]

ok. anyway thank you for help.