Thanks for the help guys,
Chancer, when I implement your code it works. When I choose the first list box the second is updated, and the previously selected item is shown in the first list box. However, that's the only thing in the first list box. If I then pull down the first list, it's got the originally selected item multiple times. Looking at the code it looks like the original array should be but I might be missing something.
Defender, I tried implementing your code and on initial load the first list box is not populated with anything. So I'm definately missing something there. Anyway, I've added my full code at the bottom if you guys wanna take a look at it. Thanks
Step 1: Select A School District
<form name="choose_campus" action="<? $SERVER['PHP_SELF'];?>" method=post>
<select name="school_dist" onchange="form.submit();"
<?php
$db_connect = mssql_connect($server', '$username', '$password');
mssql_select_db('$database, $db_connect);
$query = "SELECT DISTINCT(DIST_NAME) FROM School_Districts";
$result = mssql_query($query);
if (isset($POST['school_dist'])){
while($district = mssql_fetch_array($result)){
print "<option value=\"".$district['DIST_NAME']."\" selected>".$school_dist."</option>";
} //end while
}else{
while($district = mssql_fetch_array($result)){
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'];
($server', '$username', '$password');
mssql_select_db('$database, $db_connect);
mssql_select_db('AR_Cross', $db_connect);
$query = "SELECT * FROM CAMPUS_DIST WHERE NAME_1 = '$school_dist'";
print "<form action=\"somepage.php\" method=post>";
print "<select name=campus>";
print "<option> --School Campus-- </option>";
$result = mssql_query($query);
while($campus = mssql_fetch_array($result)) {
print "<option>".$campus[NAME];
}//end while
}else{
?>
<select name="campus" onchange="form.submit();"
<?php
($server', '$username', '$password');
mssql_select_db('$database, $db_connect);
mssql_select_db('AR_Cross', $db_connect);
$query = "SELECT DISTINCT(NAME) FROM CAMPUS_DIST";
$result = mssql_query($query);
while($campus = mssql_fetch_array($result)){
print "<option>".$campus['NAME'];
} //end while
}//end if
?>
</select>
</form>
