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
