Help?
| From: | Wee Chua | Date: | Mon, 31 Jul 2000 15:46:58 +0000 |
| Subject: | Help? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-9187@lists.php.net to get a copy of this message | ||
Hi everyone,
I have a field on the form in HTML which is a Selection with 2 options.
There are Company and Employee. For example,
Select one: <Select Name="Game">
<option value"Emp">Employee</option>
<option value"Comp">Company</option>
</Select>
Now, I want to use the selection on the form in order to retrieve the data
from such table in php. Assuming I have all the host, username and password
are correct and connected, I also have chosen the database I want to run
with. Here is the SQL statement with php. $result is a variable.
$result = mysql_query("Select * from $Game",$db);
I don't know how to pass the value from the <Select> to implement this SQL
statement. I also gave me the error message " Supplied argument is not a
valid MySQL result".
Could anyone tell me how to pass the value from <Select> into SQL statement
with php. Thanks!
Calvin