MySQL connection

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
mattp222
-


Joined: 05 Oct 2009
Posts: 4

PostPosted: Fri Oct 09, 2009 2:32 am    Post subject: MySQL connection Reply with quote

hello,

I am new to the database part of the web, and the tutorials haven't help me yet. I have the table set up how I want it, but I am having severe trouble writing the asp code to get it to connect with MySQL. such confusions are whether or not the asp code is part of its own document or whether I need to integrate it into the html page somehow.

I keep getting the http 404 error from my code and would like some help.

Code:
</address>
<center>
<b><font size=+3>Registration</font></center></b>

<FORM action="../htdocs/cgi/new.asp" method="get">
<input type="hidden" name="next"
 value="http://suutriathlonclub.webs.com/index.html"> 

First Name:
<input type="text" name="firstname"/>
<br /><br>
Last Name:
<input type="text" name="lastname" />
<br><br>
Valid E-mail:
<input type="text" name="e-mail" /> <font size=-1>(name@provider.com)</font>
<br><br>
Gender:
<input type="radio" name="CENSORED" value="male" /> Male 
 <input type="radio" name="CENSORED" value="female" /> Female

<input type="submit" value="Submit" />

</FORM>


that is my registration page and the below code is my new.asp file that I don't understand how to write it.

Code:
<%
if (Request.Form("next") = "http://suutriathlonclub.webs.com/index.html")
then

Server="../MySQL";Port=3306;Database=registration;Pwd=fF2@aA;

insert into runners
response.write(request.querystring("firstname"))
response.write(" " & request.querystring("lastname"))
response.write(" " & request.querystring("e-mail"))
response.write(" " & request.querystring("CENSORED"))
%>


please help me, I need very basic terms because SQL is new to me.
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group