Re: PHP / Query trouble

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

 



PHP Mailer skrev:
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


- Jimmie

Jay,

Your the man, solved it by removing all single quotes around the $tableName
original syntax was '".$tableName."' while i removed the quotes to '$tableName'
bad habit!

working query:
$query = mysql_query("OPTIMIZE $tableName");

Thanks a bunch dude!

- Jimmie

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[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