Passing a variable with an apostrophe

[Anon]

Hi

I am having problems passing a variable from a unix script into SQL. The variable is in the format Paddy O'Reilly.
Can anyone throw some light on the problem?

Thanks
Elaine.

[Anon]

if you are using Oracle as your database the single quote (') is used in SQL for the start and end of text. If you want a single quote to be entered in a text string you have to replace it with 2 single quotes ('').
$sql=ereg_replace("'","''",$sql);