Database inserts with '

[dkin]

Whenever I have a row in my db that has an ' I get an error whenever loading the page.

What can I do to keep it in the row but not get the error?

[arran]

dkin,

Either use double quotes for your sql or escape the string using the mysql_escape_string function.

arran.

[jatar_k]

no offence arran

from
[php.net...]

This function became deprecated, do not use this function. Instead, use mysql_real_escape_string() [php.net].

[arran]

jatar_k, no offence taken. Thanks for bringing me into the 21st century :)