OK, I'm trying to echo a list of people that are taking a class:

PHP Code:

<script language="javascript">
 function hunt_down_slot()
{ 
var a;
a=document.form1.class_selection.value;  //grabs value from dropdown menu
}
</script>
<?
$sql ="
    SELECT * from classes_taken" ;
    $result4 = mysql_query($sql);
    while ($row = mysql_fetch_array($result4)) {
      $people_id=$row['people_id'];
    $isittaken =$row['slot_1'];  //rather than '_1' I want '_a'
if ($isittaken == 1){
$sql ="
    SELECT * from people" ;
    $result5 = mysql_query($sql);
    while ($row2 = mysql_fetch_array($result5)) {
      $id=$row2['id'];
      $first_name=$row2['first_name'];
      $last_name=$row2['last_name'];
if ($id == $people_id){echo $people_id . " - " . $last_name . ", " . $first_name . "<br>";}}}}
?>

As you can see, I used "slot_1" instead of "slot_a" I can't seem to get the variable in there!

ARGH!

Thanks in advance

-Dave in IL

You mean you want the name of the php variable to depend on the javascript? The javascript runs entirely clientside, so there's no way for php to know which drop down option was clicked unless you submit the whole form and regenerate the page.

OK, I want to do that then.

Or, I want it to open in a new frame or window.

Any suggestions?

-Dave in IL

NM, I got it. Thanks for the reply.

http://www.wmaw2005.com/2005/reports/classlist.php

-Dave in IL