Problems creating a log in page

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
daniel_mintz
Forum Newbie
Posts: 3
Joined: Tue Mar 13, 2007 7:17 pm

Problems creating a log in page

Post by daniel_mintz »

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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Post your query.

Remember to use the proper syntax highlighting. ;)
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Problems creating a log in page

Post by califdon »

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'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.

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.
Post Reply