| re: How do you insert a value from drop down list to SQL table?
Ren wrote:[color=blue]
> Hi all,
>
> I am a bit new to PHP and SQL so this may seem like a dumb question.
>
> I have already created a drop down list as part of a form which is
> automatically populated with values taken from a separate database. When a
> user goes onto this page and either leaves the default value or selects a
> value from the drop down list and presses the submit button, I would like
> that selected value to be stored into a database which I have already
> created in SQL.
>
> Just to let you know that I can do the above using a text field but just
> don't know how to do it with drop down list.
>
> If your going to explain any coding then it may help if I give you the names
> of certain items that are involved.
>
> Database is called "Company"
> Field within database is called "Name"
>
> Drop down list is called "company"
>
> Thanks
> Ren
>
>[/color]
Ren,
Submit your form to a simple testpage which contains the following:
print_r($_POST);
or - depending on your php version -
print_r($HTTP_POST_VARS);
You should now see exactly what is being submitted by your form (and
how) which should tell you how you can reference the value you want to
put into your database.
Grz,
Juliette
| 
