p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Basics (http://p2p.wrox.com/forumdisplay.php?f=61)
-   -   insert values into a MySQL DB from a drop down men (http://p2p.wrox.com/showthread.php?t=24190)

crmpicco January 20th, 2005 08:08 AM

insert values into a MySQL DB from a drop down men
 
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



All times are GMT -4. The time now is 06:15 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.