???passing a query from a form???

[cabledude]

I have wrote a script to query my mysql database based up a name that is selected from an HTML list menu, the form action calls to my php script from my html doc, I have tested connectivity to the databse and have added a manual sql query to my php script to be sure it is functioning properly, the problem is I'm not sure how to get the script to see what option the html form is sending, I thought I could use:

$query = "SELECT * FROM table WHERE email = '{$_GET['selecteduser']}@mydomain.com'";

but that doesn't seem to be working properly. Maybe the HTML document is sending it correctly? Here is my form:

<form action="report_results.php" method="post">
<select name="selecteduser">
<option value="selecteduser">Select One:</option>
<option value="[e-mail]">user1</option>
<option value="[e-mail]">user2</option>
</select>
<input type="submit" name="submit" value="Go!">
</form>

This form calls to the php script which then takes the input from the HTML form and processes it into the $_GET query and sends it to the while loop in the script, I'm not sure why this is not working? Here is my php code:

<?php
  $db = mysql_connect("localhost", "sqluser", "sqlpasswd") or die("Could not connect to Mysql");
   if (!$db == False)
   {
       mysql_select_db("mydb");
      $query = "SELECT * FROM table WHERE email = '{$_GET['selecteduser']}@mydomain.com'";

   $result = mysql_query($sql,$db);
   while ($row = mysql_fetch_row($result))
   {
       print "<tr>";
             foreach ($row as $field)
             {
             print "<td>$field</td>";
             }
       print "</tr>";
   }
   mysql_close($cn);
   }
   else
   {
       print "Problem Connecting to the Database<br>";
   }
?>

Does anyone have any suggestions??

                     Thanks

[danyprundus]

Well, if you are using this:

<option value="[e-mail]">

than you your next page you should have
$POST['selecteduser']=[e-mail],
And your queryy can look something like this:

$query = 'SELECT * FROM table WHERE email = '.$_POST['selecteduser']; 

[cabledude]

should the _POST['selecteduser']=[e-mail] go into my html document? For example:

<form action="report_results.php" method="post">
<select name="selecteduser">
<option value="selecteduser">Select One:</option>
<option value="$POST['selecteduser']=[e-mail]">user1</option>
<option value="$POST['selecteduser']=[e-mail]">user2</option>
</select>
<input type="submit" name="submit" value="Go!">
</form>

Like that?

[danyprundus]

No. not like that.
You have this form

<form action="report_results.php" method="post"> 
<select name="selecteduser"> 
<option value="selecteduser">Select One:</option> 
<option value="[e-mail]">user1</option> 
<option value="[e-mail]">user2</option> 
</select> 
<input type="submit" name="submit" value="Go!"> 
</form> 
 

You press GO and you go to that page where you do this

<?php 
  $db = mysql_connect("localhost", "sqluser", "sqlpasswd") or die("Could not connect to Mysql"); 
   if (!$db == False) 
   { 
       mysql_select_db("mydb"); 
      $query = "SELECT * FROM table WHERE email = '{$_GET['selecteduser']}@mydomain.com'"; 

   $result = mysql_query($sql,$db); 
   while ($row = mysql_fetch_row($result)) 
   { 
       print "<tr>"; 
             foreach ($row as $field) 
             { 
             print "<td>$field</td>"; 
             } 
       print "</tr>"; 
   } 
   mysql_close($cn); 
   } 
   else 
   { 
       print "Problem Connecting to the Database<br>"; 
   } 
?> 

Right?
Well on this last part irn order to see what username you selected you should use

$_POST['selecteduser']

So the piece of code should look like this:

<?php 
  $db = mysql_connect("localhost", "sqluser", "sqlpasswd") or die("Could not connect to Mysql"); 
   if (!$db == False) 
   { 
       mysql_select_db("mydb"); 
    [B]  $query = 'SELECT * FROM table WHERE email = '.$_POST['selecteduser']; [/B] 
       $result = mysql_query($sql,$db); 
       while ($row = mysql_fetch_row($result)) 
       { 
           print "<tr>"; 
                 foreach ($row as $field) 
                 { 
                 print "<td>$field</td>"; 
                 } 
           print "</tr>"; 
       } 
       mysql_close($cn); 
   } 
   else 
   { 
       print "Problem Connecting to the Database<br>"; 
   } 
?> 

See what I am talking about?