getting values from a single select input

jakez

Hello,
i am trying to query all the data from a mysql table with a select statement i would like to choose the table name of the table with a select input (i currently have 2 tables in the DB named "people" & "about"):

<select name="tables">
<option>people
<option>about
</select>

now i am using a statement like this
mysql_query("SELECT * FROM $tables");

im pretty new to this but it seems as though when i submit the html form there should be a global variable availiable with the name tables and a value or either "people", or "about".

thanks alot
jacob

cgraz

Take a look at mysql's documentation on the SELECT syntax

SELECT * FROM your_table

and if you want to be more specific

SELECT * FROM your_table WHERE field_name='value'

any part of a form, whether it be a textarea, textbox, checkbox, radio, etc; php will create a value from the name you specify in the form

name = "field_name" will create a variable $field_name that holds the value the user typed in or selected.

I'm not exactly sure what you are trying to accomplish with this code. Can you be more specific and someone may be able to help you better.

Cgraz