Can't seem to capture a variable in a chained select
Posted on
16th Feb 2014 07:03 pm by
admin
I'm *this* close to having a chained select running but for some reason it doesn't seem to be picking up a variable.
Code: <?php
Did you know?Explore Trending and Topic pages for more stories like this.
require ('inc/connection.php');
//seeming that we are just submitting and refreshing to the one page we need to check if the post variable is set, and if so a couple of other variables are set
if(!isset($_POST['state'])) {
$next_dropdown = 0;
}
else {
//When set this variable reveals the next drop down menu
$next_dropdown = 1;
//this variable keeps the previous selection selected
$selected = $_POST['state'];
}
?>
<form name="form" method="post" action="">
<select name="state" style="font-size:20px;">
<option value="NULL">State</option>
<?php
$query = "SELECT id, name FROM state ORDER BY name ASC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{?>
<option value="<?php echo $row[0]; ?>" onClick="document.form.submit()" <?php if(isset($selected) && $row[0] == $selected) {echo "selected='selected'";} ?>><?php echo $row[1]; ?></option>n";
<?php }
echo '</form>n';
//this is where the other form will appear if the previous form is submitted
if($next_dropdown == 1) {?>
<form name="form2" action="" method="post">
<select name="city">
<option value="NULL">City</option>
<?php
$query2 = "SELECT * FROM city WHERE state_id = " . $row[0];
$result2 = mysql_query($query2);
while($row2 = mysql_fetch_array($result2))
{ ?>
<option value="<?php echo $row2[0]; ?>" onClick="document.form2.submit()"><?php echo $row2[1]; ?></option>
<?php }?>
</select>
</form>
<?php }
?>
The state drop down works fine. Once a state is selected, it will display the city drop down. However, the city drop down never populates. It's as though it forgets what $row[0] is. Any thoughts?
No comments posted yet
Your Answer:
Login to answer
83
35
Other forums
Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,
add text and number image
hi guys ..
ok see i want the user to add their name and pick a number then click get it and i
Image loading
Hi Developers,
I'm trying to display an image from images/image.gif getting the url from mysq
Fetching array then reversing it
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar
need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli
How to load mysql (and other) extensions into PHP
How to load mysql (and other) extensions into PHP PHP Development forum discussing coding practices,
List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab
Custom Container in module pool program
Hello everyone,
I have created a custom control in my module pool screen. Now I want to s
Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time
Help with Contact Form
I have this Form on an html page and the associated code on page.php (below).
I keep getting the