Here is a quick script Im trying to run to optimize my mysql database, however it fails on the first line, Of course all the connection information is filled out right on the real script, but I cannot see why this is not working..
mysql_connect("mysql.domain.com", "dbuser", "dbpass") or die(mysql_error());
mysql_select_db("info") or die(mysql_error());
mysql_query("OPTIMIZE TABLE 'general'")
it says "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 ''general'' at line 1"
Can anyone provide any help? Im not sure why this isnt working.