Drop down box question

[25lez25]

Would like to set up 2 drop down boxes on a page to show values from 2 different fields from a mysql table, and user makes selection from both drop down boxes, and then clicks submit to see all matching rows from table. Appreciate any help

Thanks

[leatherback]

Hi, in general:

$query ="Select id, distinct COLUMA from TABLE";
  $result = mysql_select($query);
  while ($row =@ mysql_fetch_array($result)) 
  {
   $option .="<option value=\"$row[id]\">$row[COLUMA]  </option>
   ";
   }

// end PhP code. HTML section now

<form action="someprocesscript.php" method="post">
<select name="columa">
<? echo $$option; ?>
</select>

<input type="submit">
</form>

// Then, on someprocesscript.php:

$coloma = $_post['columa'];

$query = "select * from table where COLUMA = $columa";

// continue like before from here.

Hope this helps, and is without too many typos. columa, table, id and someprocesscript.php you will obviously have to change to match your table/site..

J.

[25lez25]

Thanks. That sets up 1 drop down box only, right? how would you then also get 2nd drop down box for columb values where user doesn't click submit until they have chosen values for both columa and columb? so on initial php page need 2 drop down boxes and on the someprocessscript.php need to accept user chosen values for both columa and columb.

Thanks for help

[leatherback]

Hi,

You can do the same for "columb". I am not sure wether you can have two "distinct"selections in one query. probably not. So you have to do it this way.

in your processing page, you place instead of

$query = "select * from table where COLUMA = $columa";


$query = "select * from table where (COLUMA = $columa) AND (COLUMB = $columb)";

// To get the output from that page:

$result= mysql_query($query);
  while $outputrow =@ mysql_fetch_array($result)
  {
   echo $outputrow[COLUMA], $outputrow[COLUMB] ;
 }

hope this gets you started