Jason Hawkins wrote:

I am trying to INSERT into a MSAccess database using PHP 4.3 -
I have a problem when I enter a name like O'Donnell. In mysql I would
normally just backslash the single quote but this doesn't work with
is there a fix for this??

Thanks in adv.


Most DBs allow you to use '' to quote a single quote. So:

INSERT INTO table (name) VALUES ('O''Donnel');

Or you could do the obvious and use:

INSERT INTO table (name) VALUES ("O'Donnel");

But that doesn't work with, say Oracle. (mysql handles both quotes just fine)

paperCrane <Justin Patrin>
Question Everything, Reject Nothing

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

Reply via email to