PHPMyAdmin Problem....*SOLVED*

[Al Neri]

UPDATE!
It turns it out Magic Quotes somehow got enabled - Didnt even know wtf that was !

Problem solved!



I have PHP 5 and PHPMyAdmin, Server version: 5.0.51a-community, Protocol version: 10 installed on my server space.

When I input:

Select * from Database where FirstName='Mike'

and

Select * from Database where FirstName="Mike"

I get back (this is an example for single quotes - when i input double quotes the example comes back with double quotes):

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 37
STR: =
SQL: Select * from EmpList where FirstName=\'Mike\'


SQL query: Documentation

Select * from EmpList where FirstName=\'Mike\'

MySQL said: Documentation
#1064 - 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 '\'Mike\'' at line 1

If I click go back it shows the Query as

Select * from Database where FirstName=\'Mike\'

With the slashes added back in.

Is this a bug - or is there a workaround?

Thanks,

Don R.