ok i have a form for people to sign up which is this one:
<form method="POST" action="app.
asp">
Fields marked (*) are required
<p><font color="#990000"><strong>UserName:*</strong></font><br>
<input type="text" name="UserName" value="UserName">
<p><font color="#990000"><strong>Password:*</strong></font><br>
<input type="text" name="Password" value="Password">
<p><font color="#990000"><strong>Email:*</strong></font> "Must be a Valid Email Address"<br>
<input type="text" name="Email" value="Email">
<p><input type="submit" name="submit" value="Submit">
</form>
and i have a bit of
sql that is ment to write that data to a database but it doesnt here is the
asp bit
Dim sConnection, objConn , objRS
strusername = UserName
sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=web78-uo; UID=xxxxxxx;PASSWORD=xxxxxxxx OPTION=3"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(sConnection)
Set objRS = objConn.Execute("INSERT INTO accounts (username,password,email ) VALUES(username,password,email)")
for some reason it will not write the data from that form to the database is there somthing wrong with my script if so can any one help me fix it