Hi Kinney, On Mon, 2002-02-04 at 12:06, Kinney Baughman wrote: > Hi, > > I'm playing with PHP/MySQL for the first time having used Perl and MySQL > for years. > > In one of my first update scripts, PHP is automatically escaping quotes and > such, which I assumed was a good thing.
PHP has a group of configuration settings that control if this behavior is invoked automatically. See http://php.net/configuration. The directives that control this are all named /magic_quotes_\w+/ > However, I'm noticing that MySQL is rejecting statements like: > > Update faqs SET subject='Adding FAQ\'s' WHERE id=110 ; > > It also rejects: > > Update faqs SET subject="Adding FAQ\'s" WHERE id=110 ; By reject, do you mean that the call to mysql_query() returns FALSE or that the query does not affect the table? > I've tested these out on the MySql command line and find the same thing. > > Rows matched: 1 Changed: 0 Warnings: 0 > > It finds the row but doesn't make the change If the UPDATE query does not need to modify the fields referenced, it will have this result. Change the value for subject to a different value - your query should change the row the first time the query is run, but not the second and subsequent times. > Anyone have a suggestion for what I need to do to get the record updated? > I don't find anything in the archives or the manual that addresses this > problem. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Zak Greant <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB /_/ /_/\_, /___/\___\_\___/ Calgary, Canada <___/ 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
