SELECT list from database & form.

[Anon]

Hi, the code below allows me to print out the list of tables in my database into a SELECT list and print each one as an option. THe problem is that i cannot send the selected variable through to the script which prints out the variables, can anyone help? Thanks

Code:

include_once("standard.php");

     $dbh = mysql_connect($host, $user, $pass);
     mysql_select_db($name);
     $tables = mysql_list_tables($name);

     Print "<select name=\"select_list\">";


     while (list($bla)=mysql_fetch_array($tables)) {


     Print "\n<option value=\"$bla\" name=\"$bla\">$bla</option>";

     }


     Print "</select>";

Thanks
Chris Davis

[Anon]

i could not get a hang of your problem becos you seem to have the <form></form> tags missing.

i assume that the code you have printed is the entire thing, in which case adding the form tags will solve your problem.

HTH
steve

[Anon]

Yes, in the full script it has the form tags, but still it does not work.

Thanks

[[deleted]]

NoteL options don't have names, the only value you will get back is 'select_list' which will contain the value of the selected option.

a few things to look for:
Are you accessing the correct var after submitting? (ie: if method=post, the the HTTP_GET_VARS will be empty)
If you are looking at global vars, are you sure register_globals is on?