I am trying to create a login page. I am not too sure where actually went wrong as i keep getting this error message : Syntax Error in FROM clause. Attach is my program. I seriously need all of your help. I will greatly appreciate your help.
looks like a space is missing.... logging.asp should be
Dim sql, rs, conn
set conn = Server.CreateObject("ADODB.Connection")
conn.provider = "Microsoft.Jet.OLEDB.4.0"
sql = "Select * from User where username='" & Request.Form("user") & "'"
sql = sql & " And pwd='" & Request.Form("pwd") & "'"
Set rs = conn.Execute(sql)
<%if not rs.eof then
Thanks alot dimis and Coffee Minion. I am now able to login. I am facing any problem now and i seriously need your help. I am not sure how to display record from the database according to the latest date. I tried using the following code, and it display all the record that contains Jam, arrange according to the date in decending order. Which is not what i want.
sql = "SELECT * FROM TrafficCon WHERE Condition='Jam' ORDER BY TDate DESC"
If I only want to display record according to the latest date, how should i do? Attach is my updated database and program.