Mulitple List Box and MS SQL Question

it_is_spatial

I've got a list box that is querying a MS SQL table to populate the options. It's working fine. I'm wanting to take the selected option in the list box and query another table for that selection. Here's a snippet of code i'm using. Any help would be appreciated.

<form name="choose_parcel">
<select name="parcel_id">
<?php
$db_connect = mssql_connect('MSSQL_Server', '$username, '$password');
mssql_select_db('$table, $db_connect);
$query = "SELECT * FROM Cross_CAMA";
$result = mssql_query($query);
while($type = mssql_fetch_array($result)){
print "<option>".$type[parcel_id];
}
?>
</select>

bastien

if (isset($_POST['parcel_id']){
  $pid = $_POST['parcel_id'];
}

$db_connect = mssql_connect('MSSQL_Server', '$username, '$password'); 

mssql_select_db('$table, $db_connect); 

//assumes $pid is totally numeric - else add single quotes around the value
$query = "SELECT * FROM tableName where parcel_id = $pid"; 

$result = mssql_query($query); 
while($type = mssql_fetch_array($result)){ 
....

it_is_spatial

Thanks for the swift reply. I've made an attempt at adding your code to my form to no avail (of coarse). I've added the form below I'm sure I'm missing something small since I'm brand new to PHP. Thanks in advance for any help.

<select name="parcel_id">
<?
if (isset($POST['parcel_type'])
$pid = $POST['parcel_type'];//Getting an unexpected T_VARIABLE here
}

$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein');

mssql_select_db('AR_Cross', $db_connect);

$query = "SELECT * FROM Cross_CAMA WHERE type = '$pid'";

$result = mssql_query($query);
while($parcel = mssql_fetch_array($result)){
print "<option>".$parcel[parcel_id];
}
?>
</form>

bastien

You do realize that you need to SUBMIT your selected option to the server to get my code sample to work...ie it needs to be made into another page

it_is_spatial

I noticed that after I sent my reply. I'm looking at putting it in a function and calling the function from the onchange of the first select box. Any ideas on that?

bastien

as long as it gets submitted, the onchange is fine, it relieves the user of the need to press the submit button

it_is_spatial

Gave it my best shot. It doesn't like my IF.

<?
function UpdateParcel()
if (isset($POST['parcel_type']){
$par_type = $POST['parcel_type'];
}
$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein');
mssql_select_db('AR_Cross', $db_connect);
$query = "SELECT * FROM Cross_CAMA WHERE type = '$par_type'";

$result = mssql_query($query);
while($parcel = mssql_fetch_array($result)) {
   print "<select name="parcel_id">"
   print "<option>--Select Parcel ID--"
   print "<option>".$parcel[parcel_id];
}

?>
<form name="choose_campus">
<select name="parcel_type" onchange="UpdateParcel()">
<?php
$db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein');
mssql_select_db('AR_Cross', $db_connect);
$query = "SELECT * FROM Cross_CAMA";
$result = mssql_query($query);
while($type = mssql_fetch_array($result)){
print "<option>".$type[type];
}
?>
</select>

</form>

dfownz

I'm not to sure about PHP, but in C++ you have to have a function in {}'s. So, try adding a { after the first ()'s and then another } at the end of it.

Hope it fixes it.

bastien

try this: You will need to change the destination of the first form from somepage.php to whatever page you have to show query the db for the specific item...

Notes: You cannot call a php function with a clienside onChange..it simply doesn't know about it

you also had the select and initial option in the incorrect place...they would have looped with every record and cause some html weirdess when rendered

<? 

if (isset($_POST['parcel_type']){ 
  $par_type = $_POST['parcel_type']; 

  $db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein'); 
  mssql_select_db('AR_Cross', $db_connect); 
  $query = "SELECT * FROM Cross_CAMA WHERE type = '$par_type'"; 
   print "<form action=\"somepage.php\" method=post>";
   print "<select name="parcel_id">"; 
   print "<option>--Select Parcel ID--";
  $result = mssql_query($query); 
  while($parcel = mssql_fetch_array($result)) { 
    print "<option>".$parcel[parcel_id]; 
  }//end while
}else{ 
  ?> 
  <form name="choose_campus" action="<$_SERVER['PHP_SELF'];?>" method=post> 
  <select name="parcel_type" onchange="form.submit();"
  <?php 
  $db_connect = mssql_connect('AGIO-7NWEIO', 'tmp_PHP', 'letmein'); 
  mssql_select_db('AR_Cross', $db_connect); 
  $query = "SELECT distinct(type) FROM Cross_CAMA"; 
  $result = mssql_query($query); 
  while($type = mssql_fetch_array($result)){ 
    print "<option>".$type['type']; 
  } //end while
}//end if
?> 
</select> 

</form>

it_is_spatial

Thanks it worked. I had a few syntax errors in the code I had before but fixed that up. Thanks for walking me through it. (well basically building it for me)
Just for others Here's the final code.

if (isset($POST['parcel_type'])){

$par_type = $POST['parcel_type'];

$db_connect = mssql_connect($server', '$username, '$password');

mssql_select_db('$table', $db_connect);

$query = "SELECT * FROM Cross_CAMA WHERE type = '$par_type'";

print "<form action=\"somepage.php\" method=post>";
print "<select name=parcel_id>";

$result = mssql_query($query);

while($parcel = mssql_fetch_array($result)) {

print "<option>".$parcel[parcel_id];

}//end while
}else{

?>

<form name="choose_campus" action="<? $_SERVER['PHP_SELF'];?>" method=post>
<select name="parcel_type" onchange="form.submit();"
<?php

$db_connect = mssql_connect($server', '$username, '$password');

mssql_select_db('$table', $db_connect);

$query = "SELECT distinct(type) FROM Cross_CAMA";

$result = mssql_query($query);

while($type = mssql_fetch_array($result)){

print "<option>".$type['type'];

} //end while
}//end if
?>

</select>

</form>