PHP \'s

[iainsmith4]

Hi all, I am trying to display on my page a name from a MYSQL database where the name is "iain's".

When it stored in the database it is done as "iain\'s" as I have filtered the inputing of the data into the database.

Now I want to display this back on a page as "iain's" without the slash and making sure it is clean data.

How would I go about this is the str_replace the best

ie: <?php echo str_replace("\\", "",$row_rsRecord['name']); ?>

or is there another way?

[jatar_k]

[php.net...]

[Anyango]

have you used addslashes() before saving the data ? try using stripslashes() on the data before you output. Best would be to use mysql_real_escape_string() and you wont have to worry about formatting output when you display (apart from other benefits).

[iainsmith4]

Hi Anyango, many thanks for your help! that stripslashes() worked a treat! Cheers

Iain

[omoutop]

actually it's what jatar_k suggested at first :)

[Anyango]

Yep he did first, sorry we were both typing the post at same time so i didnt get to see his jatar_k's response before posting my message.

[iainsmith4]

Not a problem guys, thanks for the help anyway from both, much appricated!