RE: PHP / Query trouble

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[snip]

 [snip]
  

	    $optimizeTableQuery = mysql_query("OPTIMIZE TABLE
	'".$tableName."'");
	    

[/snip]
 
Take the single quotes away from the table name. 
 
http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html
 
Make sure they are the right kind of tables.
 

Tried that already, and same results.
Can't seem to figure this one out. 
Current snippet:
[/snip]

 

Make sure to hit reply all just in case your e-mail goes to a spam
folder. That way others on the list can see and perhaps help.

 

Does the user have permissions to optimize tables?




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux