mattp222 -
Joined: 05 Oct 2009 Posts: 4
|
Posted: Fri Oct 09, 2009 2:32 am Post subject: MySQL connection |
|
|
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. |
|