Variables with a ' in mysql queries

[nexgen_x]

If a variable has an apostrophie, such as "Bob's cat", it seems to cause problems when querying mySQL (because the ' is also used for describing values of fields)... anyone know a way around this?

Cheers,

[Bunkermaster]

[MAN]addslashes[/MAN] 🙂

[jerdo]

Add a slash before the apostrophe (\'). I think you can do this with addslashes() or you can use a preg_replace/ereg_replace.

[nexgen_x]

thought so, just wasn't sure if escaping was the same for SQL queries as it is for normal php coding...

Thanks