Jhone Posted March 26, 2009 Share Posted March 26, 2009 hi! <% dim fname,lname,user_password,fullname -----<---------this varisbles are form . html >'if submit(login)<>""true thenfullname=request.form("fullname") name1=Request.form("fname") name2=Request.form("lname") password=Request.form("user_password") sql="insert into usertable (fname,lname,user_password) values ('"&fname&"','"&lname&"','"&user_password&"')" conn.execute(sql) 'sql="select * top 3 from password_setting where ID=50" 'set rt=conn.execute(sql) Response.write("Hai!.."&fullname&" ") Response.Write("Ur account is added in our database") 'End if%>i create database and table with usertable as table name, if i enter details in form & when i submit query it Display "Ur account is added in our database"but in table details not addingfor hlp iam very thankful Link to comment Share on other sites More sharing options...
Synook Posted March 26, 2009 Share Posted March 26, 2009 Why have you commented out the lines that actually add the information to the database? Link to comment Share on other sites More sharing options...
justsomeguy Posted March 26, 2009 Share Posted March 26, 2009 It looks like the insert is uncommented. But it would probably be a good idea to check the variable names in the query with the variables that have the form data. Link to comment Share on other sites More sharing options...
Synook Posted March 27, 2009 Share Posted March 27, 2009 Oops you are right JSG - I was looking at the wrong line Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.