Dynamic Dropdown Issues STill

rayge

Well I can get Part of the page to load But the Second part doesnt seem to work.
Its just a TEST page for now so its only pulling the State in one drop down and areacode FOR that state in another dropdown.
Once it works it will be used to get the states for any country.

The problem is i cant seem to get the Areacode part to work. here is the Dbase info

Dbase = test
Table1 = state
Fields = Name, ID
Table2 = areacode
Fields = Code, state

The Primary Key is ID and the Relative fieldd would be ID and state. So if the ID for alabama is 1 Then it should Pull from areacode anything that has 1 in the state field. Its not being a happy camper. I would appreciate any help.

heres my code below,

<?
mysql_connect("Server", "name", "password") or
Die ("could not connect to DB");

mysql_select_db("test")or
Die ("could not Select DB");

$Result1 = mysql_query ("select * from state") or
Die (mysql_error());

$Result2 = mysql_query ("Select * from areacode where state = '".${"ID"}."'") or
Die (mysql_error());

?>
<? while ($recB = mysql_fetch_array($Result2)) { ?>
<? echo ("$recB"); ?>
<? }?>
<form method="post" name="signup" action="<?= $PHP_SELF ?>">
<select name="xcountry" onchange="document.signup.elements['State'].value = this.options[this.options.selectedIndex].value; document.signup.submit()">

<? while ($recA = mysql_fetch_array($Result1)) { ?>
<option value="<? echo $recA["Name"]; ?>"> <? echo $recA["Name"]; ?> </option>
<? } ?>
</select>

<? while ($recB = mysql_fetch_array($Result2)) { ?>
<option value="<? echo $recB["Code"]; ?>"> <? echo $recB["Code"]; ?> </option>

<? } ?>
</select>

</form>

rayge

anyone have any suggestions on what im doing wrong here?

[deleted]

You are using $result2 twice without resetting the resultset.

rayge

Even after removing the first $Result set i still get the error. It must be a bigger issue than that. ;-(
Would you mind trying the code out and seeing why its not working?

Current code below. database info in first post.

<?
mysql_connect("server", "username", "password") or
Die ("could not connect to DB");

mysql_select_db("test")or
Die ("could not Select DB");

$Result1 = mysql_query ("select * from state") or
Die (mysql_error());

$Result2 = mysql_query ("Select * from areacode where state = '".${"ID"}."'") or
Die (mysql_error());

?>
<form method="post" name="signup" action="<?= $PHP_SELF ?>">
<select name="xcountry" onchange="document.signup.elements['State'].value = this.options[this.options.selectedIndex].value; document.signup.submit()">

<? while ($recA = mysql_fetch_array($Result1)) { ?>
<option value="<? echo $recA["Name"]; ?>"> <? echo $recA["Name"]; ?> </option>
<? } ?>
</select>

<? while ($recB = mysql_fetch_array($Result2)) { ?>
<option value="<? echo $recB["Code"]; ?>"> <? echo $recB["Code"]; ?> </option>

<? } ?>
</select>

</form>

[deleted]

what's the error you get?

rayge

Well i dont get an error but nothing shows up in the Second field.

[deleted]

Have a look at the html code, is it 100% valid?

Also, are you sure the second query even returns any data at all?

Pring the query before you execute it, see if it does what you expect it to. Run manually from the commandline and see what happens.

rayge

Okay well I had a friend do it in asp and it works FINE. but ofcourse I cant keep it in asp and MSSQL so i need to figure out how to convert it to MYSQL and PHP.
I have the asp2php converter but its not as good as i would hope but it is still really good.

Could somone take a stab at how to convert this?

<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "DSN=test;uid=username;pwd=password"
objConn.Open

	showstate = Request("showstate")
		if showstate = "" then
			showstate = 2
		else
			showstate = Cint(showstate)
		end if

%>
<script>
function swapit(id){
document.regform.showstate.value = id
document.regform.action = "seltest.asp"
document.regform.submit()
}
</script>

<form name="regform" method="post" action="somefile.asp">
<input type="hidden" name="showstate" value="<%=Request("showstate")%>">
<Select name="state" onchange="swapit(this.options[this.options.selectedIndex].value)">
<option value="-1"> chose a state </option>
<%
set res = objConn.Execute("Select * from state")
while not res.eof
stateid = res("id")
statename = res("statename")
%>
<option value="<%=stateid%>" <% if stateid = showstate then%>selected<%end if%>><%=statename%></option>
<%
res.movenext
wend
%>
</select>

<% if showstate <> "" then %>
<Select name="areacode">
<%
set res = objConn.Execute("Select * from areacode where stateid = '"&showstate&"'")
while not res.eof
areaid = res("id")
areacode = res("areacode")
stateid = res("stateID")
%>
<option value="<%=areaid%>"><%=areacode%></option>
<%
res.movenext
wend
%>
</select>
<% end if %>

</form>

<%
objConn.close
%>

[deleted]

did you print the query that this scrit is running?

rayge

that the Old on i was working on? It worked but it was somthing i dunno what it was..

HERES the good news. I got it working by converting the code to php and making minor modifications :-))

Heres teh script so OTHERS can use it too.

$Host = "localhost";
$DBUser = "username";
$DBPass = "password";
$DBName = "test";

$objConn=mysql_connect($Host,$DBUser,$DBPass);
mysql_select_db($DBName,$objConn);

$showstate=${"showstate"};
if ($showstate=="")
{

$showstate=2;
}
else
{

$showstate=intval($showstate);
}

?>
<script>
function swapit(id){
document.regform.showstate.value = id
document.regform.action = "seltest.php"
document.regform.submit()
}
</script>

<form name="regform" method="post" action="somefile.php">
<input type="hidden" name="showstate" value="<? echo ${"showstate"}; ?>">
<Select name="state" onchange="swapit(this.options[this.options.selectedIndex].value)">
<option value="-1"> chose a state </option>
<?
$res_query=mysql_query(("Select * from state"),$objConn);
$res=mysql_fetch_array($res_query);
while(!($res==0))
{

$stateid=$res["id"];
$statename=$res["statename"];
?>
<option value="<? echo $stateid; ?>" <? if ($stateid==$showstate)
{
?>selected<? } ?>><? echo $statename; ?></option>
<?
$res=mysql_fetch_array($res_query);

}
?>
</select>

<? if ($showstate!="")
{
?>
<Select name="areacode">
<?
$res_query=mysql_query(("Select * from areacode where stateid = '".$showstate."'"),$objConn);

$res=mysql_fetch_array($res_query);
while(!($res==0))
{

$areaid=$res["id"];
$areacode=$res["areacode"];
$stateid=$res["stateid"];

?>
<option value="<? echo $areaid; ?>"><? echo $areacode; ?></option>
<?
$res=mysql_fetch_array($res_query);

}
?>
</select>
<? } ?>

</form>

<?
mysql_close($objConn);
?>