SQL gurus: A few days ago we went live with a PHP/MySQL site. One of the pages requires entry of a username and password. If a corresponding record is found in the password table, the next page appears.
The authentication technique we used was a session variable. For most users, but not all, the server returned "You have an error in your SQL syntax near '' at line 1". So we passed the variable in the URL, and most users still get the same error message. Today I experimented on two computers. One consistently got the error message; the other consistently did not get the error message. Both computers were Win98SE with IE6.0. Their Win 98 and IE settings were identical (except for trivial stuff like home page and mouse controllers). They are on the same network. My partner and I are completely baffled by this. How can a Web page generate an SQL error on one computer, but not on an identical computer on the same network? Do any of you have suggestions for diagnosing something like this? Or maybe you have the secret for fixing the problem? Is this the proper list for asking a question like this, or would other lists or forums be more appropriate? Thanks in advance for any advice! Ken Elder Oklahoma City
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
