dreamweaver, easy php ,mysql problem

Report · Aug 03, 2008

good morning to all, I have a problem with dreamweaver cs3 and l' integration with easyphp (especially with my sql) of continuation bringing back l' error that appears to me: Error of sintax in query the SQL near ' @yahoo.it AND pwd=' 190679' ' line 1
L' error appears to me when I interrogate my databese during login (the serveur behavior) I have used the method described in book dreamweaver 8 with asp php ecfm of jeffrey bardzell, continuous Ph.D but to receive this error of continuation place a code's page:

Report · Aug 24, 2008

@marco792005

Based on the information you have provided I do no think the problem has anything to do with this code, but rather with your connection to the database. First you should be able to go into Dreamweaver and Manage Sites and test your connection to web server. Next go to the database tab in the Applications panel and confirm that the connection to the database tests out OK. Dreamweaver should write the code for the connection to the database in your connctions/conn_newland.php file. If you've filled out the fields in the database window correctly and it tests and you still get the error, please post back here.

Bob

Report · Aug 24, 2008

marco792005 wrote:
> good morning to all, I have a problem with dreamweaver cs3 and l' integration
> with easyphp (especially with my sql) of continuation bringing back l' error
> that appears to me: Error of sintax in query the SQL near ' @yahoo.it AND pwd='
> 190679' ' line 1

The error message says that it's a problem with the SQL syntax. MySQL
syntax error messages always refer to "near ...", which means the error
is immediately before that point. Looking at the rest of the message,
the problem lies with the value for user. That is, indeed, confirmed by
this line of code:

> $LoginRS__query=sprintf("SELECT `user`, pwd, userGroup FROM
> user_tecnicaldeko WHERE `user`=%s AND pwd=%s",
> GetSQLValueString($loginUsername, "-1"), GetSQLValueString($password,
> "text"));

I have no idea how this happened, because that line of code should have
been created by Dreamweaver, but the "-1" is completely wrong. The code
should look like this:

$LoginRS__query=sprintf("SELECT `user`, pwd, userGroup FROM
user_tecnicaldeko WHERE `user`=%s AND pwd=%s",
GetSQLValueString($loginUsername, "text"), GetSQLValueString($password,
"text"));

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/