Hi. I have just used dreamweaver to enter a form that allows users to enter a user name and password.
I then use the the Log In user function to identify this with the relevant fields in my My SQL database.
When I enter data In this example " John" for the user name and "jack" for the password I get this error message. What does this message mean in simple english?
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name='john' AND Password='jack'' at line 1"
Many thanks
Daniel
Problems creating a log in page
Moderator: General Moderators
-
daniel_mintz
- Forum Newbie
- Posts: 3
- Joined: Tue Mar 13, 2007 7:17 pm
Re: Problems creating a log in page
I'd say that is in simple english. It is telling you that your SQL string has an error in it, and it won't work until you fix it. It is suggesting that you check the manual to determine what is wrong. It even tells you where your syntax is wrong, just before where the SQL string has Name='john' AND Password='jack' and then gives you the line number where the error occurred. I don't know what else you expect it to say.daniel_mintz wrote:What does this message mean in simple english?
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name='john' AND Password='jack'' at line 1"
I think what you're saying is that you are using Dreamweaver, but have never used PHP and/or SQL. In that case, you're going to have a problem if Dreamweaver creates code with errors in it.