Pekka,
Thursday, July 25, 2002, 7:13:45 PM, you wrote:
PS On my application's setup.php I have quite simple MySQL queries like
PS DROP TABLE IF EXISTS `ee_test`
PS Now, some users (perhaps 5 out of 1000) complain that they get an SQL error
PS on the first query with backquotes, and when I provided them with a setup
PS file without any backquotes (luckily all my table and row names are very
PS simple) like...
PS DROP TABLE IF EXISTS ee_test
PS ...and they reported that it worked just fine.
PS Some users had an older MySQL, but this has been reported happen also in
PS e.g. 3.23.39.
PS PHP used is always 4.0.6 or newer.
PS Any ideas why some MySQL's give error with standard backquotes and how to
PS fix this??? I'd really like to know what is going on there.
PS http://www.mysql.com/doc/L/e/Legal_names.html tells backquotes really must
PS be there.
I tested it on 3.23.51 and 4.0.2 and it worked well via PHP script and
via mysql command-line client.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php