replace part of string

[map200uk]

hi,

 

just found a problem with part of my project if a ' is present then it screws up the sql query-

 

so, i need toget rid of it, would the best way be to,

 

use regex, and see if string a contains a ' || string b etc

 

and if so, use str_replace("'","",$string);

 

thanks

 

mark

[chigley]

Why not just use addslashes() and stripslashes()

 

If you really want to remove them:

 

<?php

$string = "O'neil";
$string = str_replace("'", "", $string);
echo $string; // Oneil

?>

[map200uk]

if i did add slashes this would remove the issue with the mysql query?

 

possibly a better way to handle it than check every string and remove '?

 

thanks

[chigley]

If you add slashes before inserting into the database, this will solve all the problems. You probably don't even need to strip them again later on!

[map200uk]

yep solved thanks bud, now to solve the next problem lol

[boo_lolly]

have you tried mysql_real_escape_string()?