SQL error while using mysql_query() but not in PHPMyAdmin

I get the following error:

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 '1' at line 1

My query is:

SELECT * FROM  `history` LIMIT 0 , 30

When I run it in PHPMyAdmin it works fine, and the database con开发者_开发技巧nection is working.

EDIT: Okay this is solved. My FTP client was saying it was copying the file to the server but when I tried to open the file in cpanle's file manager it was corrupted.

Try using "real" single quotes or leave them out altogether in PHP instead of the "tilted" ones that PhpMyAdmin gives you.

$query = "SELECT * FROM history LIMIT 0, 30";

should work.

Make sure you type your own ', if you copy the query from phpmyadmin the apostrophies are different then the ones you type, like this 'history'