RE: [PHP] PHP / Query trouble
| From: | Jay Blanchard | Date: | Fri, 24 Mar 2006 03:12:50 +0000 |
| Subject: | RE: [PHP] PHP / Query trouble | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-232512@lists.php.net to get a copy of this message | ||
[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?