Re: [PHP-DB] Apostrophe problem on Firebird

2003-11-06 Thread CPT John W. Holmes
From: "Evan Morris" <[EMAIL PROTECTED]> > I have data in a database that may contain apostrophes. Some databases use the backslash character as an escape character for single quotes, while others use another single quote. Try your query such as: SELECT * FROM Table WHERE name = 'o''mallery' Ins

[PHP-DB] Apostrophe problem on Firebird

2003-11-06 Thread Evan Morris
This problem has probably already been solved (and may even already be a FAQ), but I can't find the answer and I've tried various things. I have data in a database that may contain apostrophes. I am passing variables from a form to a search facility. Essentially, I want a sql query that looks li