PHP Mysql Optimization Error

software development

#1

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’”)
or die(mysql_error());

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.


#2

I believe you need to omit the single quotes around the table name:mysql_query("optimize table general") or die("Query failed: ".mysql_error());--------
Simon Jessey | Keystone Websites
Save $97 on yearly plans with promo code [color=#CC0000]SCJESSEY97[/color]


#3

Thanks, that seems to fix the problem, I cant believe I didnt try that…