href a listbox onchange

[it_is_spatial]

I've got a dynamic multi-list box that I am working on. I've got the list boxes working. Now I want to use the second selected item as a variable in a URL through the onchange or onsubmit.

Here's my full code. Any help would be great, Thanks

<?php
$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein');
mssql_select_db('AR_Cross', $db_connect);
$query1 = "SELECT DISTINCT(DIST_NAME) FROM School_Districts";
$result1 = mssql_query($query1);

$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein');
mssql_select_db('AR_Cross', $db_connect);
$query2 = "SELECT DISTINCT(NAME) FROM CAMPUS_DIST";
$result2 = mssql_query($query2);
?>
Step 1: Select A School District
<form name="choose_campus" action="<? $SERVER['PHP_SELF'];?>" method=post>
<select name="school_dist" onchange="form.submit();"
<?
if (isset($POST['school_dist'])){

while($district = mssql_fetch_array($result1)){

IF($_POST['school_dist'] == $district['DIST_NAME']){
print "<option value=\"".$district['DIST_NAME']."\" selected>".$school_dist."</option>";

} else {
print "<option>".$district['DIST_NAME']."</option>";
} //end inner if
} //end while
}else{
while($district = mssql_fetch_array($result1)){
print "<option>".$district['DIST_NAME'];
} //end while
} //end if
?>
</select> <p>

Step 2: Select A School Campus <p>

<?
if (isset($POST['school_dist'])){
$school_dist = $POST['school_dist'];
$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein');
mssql_select_db('AR_Cross', $db_connect);
$query3 = "SELECT * FROM CAMPUS_DIST WHERE NAME_1 = '$school_dist'";
print "<form action=\"http:\maps.state.ar.us\" method=post onSubmit=\"return onlinejumpMenu()\">";
print "<select name=campus onchange=\"form.submit()\"";

$result3 = mssql_query($query3);
while($campus = mssql_fetch_array($result3)) {
print "<option>".$campus[NAME];
}//end while
}else{
?>
<select name="campus"
<?
while($campus = mssql_fetch_array($result2)){
print "<option>".$campus['NAME'];
} //end while
}//end if
?>
</select>
</form>

[TheDefender]

There are a lot of issues with this code, so where to begin...

The first part is fine, but if you want two separate forms (just a guess, since you open two different <form> tags; one for each select), then you need to close your first form with the </form> tag.

In step 2, you have two separate select tages named campus... Which one are you planning to use?

In step 2, your form posts to http:\maps.state.ar.us... Did you mean to do this? If so, are you sure you can post your variables to their default page there?

Throughout the code, you are sporadically using and not using the quotes on your attributes... Some of them, you use something like method=post, but in others, you are doing name="campus". You should be consistent to avoid problems. Take a look at the W3C's specs for HTML and XHTML, so you can begin to properly code HTML. (Hint: You should always quote your attributes)

In step 2, you have a line that reads:
print "<option>".$campus[NAME];

You aren't defining any value for the OPTION tag, so it has no value when you submit it...

You got a lot of cleanup to do...

Also, when you post your code, encluse it in the "[ php ][ /php ]" brackets using the PHP button above the area where you enter your post. It color codes things, and makes things easier to see.

[it_is_spatial]

Ok. I went through and cleaned up my code. It works with querying the database and returning what I want. Right now the second list box is not really submitting to anything. I wanted to change the code so that it would submit to a url with the variable as a parameter. Any help would be great. Thanks

<?php 
$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein'); 
mssql_select_db('AR_Cross', $db_connect); 
$query1 = "SELECT DISTINCT(DIST_NAME) FROM School_Districts"; 
$result1 = mssql_query($query1);

$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein'); 
 mssql_select_db('AR_Cross', $db_connect); 
 $query2 = "SELECT DISTINCT(NAME) FROM CAMPUS_DIST"; 
 $result2 = mssql_query($query2);
?>
Step 1: Select A School District 
<?
print "<form name=choose_campus action=".$_SERVER['PHP_SELF']." method=post>";
print "<select name=school_dist onchange=form.submit()";
if (isset($_POST['school_dist'])){  

    while($district = mssql_fetch_array($result1)){  

        IF($_POST['school_dist'] == $district['DIST_NAME']){ 
            print "<option value=\"".$district['DIST_NAME']."\" selected>".$school_dist."</option>";  

        } else { 
            print "<option>".$district['DIST_NAME']."</option>"; 
        } //end inner if 
    } //end while 
}else{  

  while($district = mssql_fetch_array($result1)){ 
    print "<option>".$district['DIST_NAME']; 
  } //end while 
} //end if 
?> 
</select> <p> 

Step 2: Select A School Campus <p> 

<? 
print "<select name=campus onchange=form.submit()";
if (isset($_POST['school_dist'])){ 
  $school_dist = $_POST['school_dist']; 
  $db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein'); 
  mssql_select_db('AR_Cross', $db_connect); 
  $query3 = "SELECT * FROM CAMPUS_DIST WHERE NAME_1 = '$school_dist'";   

  $result3 = mssql_query($query3); 
   while($campus = mssql_fetch_array($result3)) { 
     print "<option>".$campus[NAME]; 
   }//end while 
}else{ 
  while($campus = mssql_fetch_array($result2)){ 
      print "<option>".$campus['NAME']; 
    } //end while 
}//end if 
?> 
</select> 
</form>