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.
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 ;
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.
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.
Thanks.
+-----------------------------------------------------------------------+
| Kinney Baughman Appalachian State University |
| Appalachian Regional Development Institute Boone, NC 28608 |
| Email: [EMAIL PROTECTED] Phone: (828) 262-6523 |
+-----------------------------------------------------------------------+
---------------------------------------------------------------------
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
