Chris skrev:
PHP Mailer wrote:
Jay Blanchard skrev:
[snip]
User i am running is locally granted all in permission.
Using reply =)
[/snip]
Use reply-all, that way if the person that was helping you is not there
any more others can help.
Echo the query statement out and see what it looks like. Please post
that to the list.
Jay,
Sure thing, my apologies.
Notice, the error comes with all checkboxes checked (all values
passed etc), if only one box checked the error will only occur for
that box.
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 ''define'' at line 1You 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 1You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near ''track'' at line
1You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near
Read Jay's suggestion.
After this line:
$optimizeTableQuery = mysql_query("OPTIMIZE TABLE ".$tableName);
add:
echo $optimizeTableQuery . "<br/>";
and see exactly what it's trying to do.
Hey Chris,
Solved with Jay's suggestion earlier
Thanks!
- Jimmie
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
