This problem really sucks.
If you're using phpMyAdmin or just PHP with a SQL query like:
SELECT * FROM table WHERE state='NY' LIMIT 10
It may or may not work. This is driving all in our office crazy, because logging into MySQL at the command prompt and typing the exact statement directly into the MySQL prompt works everytime!
To make it even more weird... I did a regular browse in phpMyAdmin and copied the statement generated by phpMyAdmin to run, and it did not work! But it works perfectly when I click on Browse in phMyAdmin.
Anyone have any suggestions? What gives?
If you're using phpMyAdmin or just PHP with a SQL query like:
SELECT * FROM table WHERE state='NY' LIMIT 10
It may or may not work. This is driving all in our office crazy, because logging into MySQL at the command prompt and typing the exact statement directly into the MySQL prompt works everytime!
To make it even more weird... I did a regular browse in phpMyAdmin and copied the statement generated by phpMyAdmin to run, and it did not work! But it works perfectly when I click on Browse in phMyAdmin.
Anyone have any suggestions? What gives?