[FX.php List] Searching w/ string containing a single quote

Bob Patin bob at patin.com
Thu Apr 19 16:15:17 MDT 2007


I'm working on a simple query, and when I try to search for "St.  
Robert's" the search fails. Then I remove the single quote and the  
search succeeds.

I tried using STRIPSLASHES to solve the problem, but is that's not  
making any difference.

Is there a command I need to use on the string to make my search  
work? I tried

preg_quote($searchterm, '/');

but that escaped the period but not the single quote, which is the  
problem. I know it's simple, but I haven't found it on php.net yet...

Thanks for any help,

Bob




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070419/0ec8f62f/attachment.html


More information about the FX.php_List mailing list