How to store name such as O'Keefe

Hi,

I need some help on how to store name such as O'Keefe on MYSQL. When I store it from a text input, it get store as OKeefe.

Thanks,

Claude

Convert the special characters to their HTML equivalents.

easiest would be to AddSlashes when putting it in and then StripSlashes when reading it out.
Its in the string fuctions of the php manual

ie
$body=addslashes($body);

b4 your insert stmt

hth t

------------------
cheers

Not sure what you're scrip is written in, but you need to replace the single tick in your input with a double tick ('', not ").

SQL stores this string as a single tick.

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>ereg_replace("'","''",$string_with_single_quotes);[/code]




[This message has been edited by jodonnell (edited February 24, 2000).]

jodonnell,

MySQL using the backslash to escape, not the tick.

While ' is not technically an escape, you can use '' (TWO SINGLE QUOTES) within a query string to denote a single quote:

SELECT * FROM some_table WHERE some_column ='Isn''t this nice?'

will return results where some_column = Isn't this nice?

-TM


[This message has been edited by TroutMask (edited February 24, 2000).]

Thanks
I must have missed the AddSlashes and StripSlashes. Of course, now I'll have to go back and rewrite those parts of my code.

Just thought I'd share this tip. You can also use magic_quotes_gpc and/or enable_magic_quotes. I assume the enable_magic_quotes is a compiler option when building PHP as an Apache module and the magic_quotes_gpc is an Apache directive. Anybody got the real scoop on these two?

Rob