insert values into a MySQL DB from a drop down men

crmpicco · January 20th, 2005, 08:08 AM

Can anyone tell me how to insert values into a MySQL DB from a drop down menu?

Cheers.

Picco

Santhi · January 20th, 2005, 08:11 AM

Submit the page when the dropdown list is selected and write logic to insert values.

crmpicco · January 20th, 2005, 08:14 AM

<select>
<option>3 days</option>
<option>4 days</option>
<option>5 days</option>
</select>

I want to insert the selected value into a MySQL DB table called 'company' and a column called 'adv_book_time'.

Syntax?

Picco

ChrisScott · January 20th, 2005, 08:18 AM

Code:

INSERT INTO company(adv_book_time) VALUES('[your value here]');

HTH,

Chris

crmpicco · January 20th, 2005, 08:21 AM

VALUES('[your value here]');

What is my value though? It could change any time? i.e. 3 days, 4days etc......

Picco

thanks

crmpicco · January 20th, 2005, 08:25 AM

is there anything i need to do to my <select> tags before i can add to DB?

ChrisScott · January 20th, 2005, 08:29 AM

You'll need to grab the value from your form post, and add it to your query...

Code:

Dim myValue: myValue = Trim(Request.Form(YourFormFieldName))
If myValue <> "" Then
    Dim myQuery: myQuery = "INSERT INTO company(adv_book_time) VALUES('" & Replace(myValue, "'", "''") & "');"
    run your query against db here...
End If

Cheers,

Chris

crmpicco · January 20th, 2005, 08:34 AM

thats not in ASP code is it? slightly confused by the Dim function - never used it before. the form name is 'form' and the form field name is adv_book_time. thanks for your help. Picco

ChrisScott · January 20th, 2005, 08:40 AM

Yep, it's ASP.

Dim just declares a variable before you use it.

You can get the value using Request.Form("adv_book_time")

crmpicco · January 20th, 2005, 08:44 AM

You can get the value using Request.Form("adv_book_time")

this will only work on the next page? is that right?

<select class="input" name="adv_book_time" id="adv_book_time">
<option value="1">1 day</option>
<option value="2">2 days</option>
<option selected="selected" value="3">3 days</option>
</select>
<%
request.form("adv_book_time")
%>

i'm not getting anything.....

Picco