Returning input resuls on the same page

[bschwartz]

Is it possible to have results from a drop down (select/combo box) returned to the same page and use that returned value to run a query?
(Or is there a better way to do this whole thing?? 😕 )

Example:

$employee_query = "select * from table_name;

if ($emq = mysql_query($employee_query)){
while ($row = mysql_fetch_array($emq) ) {
echo '<option value="'.$row['Employee_Key'].'">
'.$row['Employee_Name'].'</option>'.
"\r\n"; }}

$emp444 = $_POST['employee2'];
$employee_name444 = mysql_query ("select * from table_name where Employee_Key like'$emp444'");

$employee_name444 = mysql_fetch_row($employee_name444);
print "$employee_name444[1] <br>";
print $employee_name444[2];

Thanks for any help!!

[KingWylim]

Yes you could do a

if(!$_POST['your field name here'])
{ 
display your menu here 
} else { 
run your query.
}

it's quite simple. 🙂 hope this helps.

Of course you'll have to set the form to post to the same page is all.