Issue with mysql SELECT stmnt and PHP

[acidbox]

I am trying to SELECT somthing from a database, but I have an issue with the statement.

Basically, i am trying to do this:

SELECT * FROM names WHERE username = Oden'haran

The issue is that the name has a ' in the middle of it, which is causing MYSQL to truncate the name and thus causing a resource error in my script.

Is there anyway to tell MYSQL to accept the ' as a regular character while placed in the middle of the string?

[ludri]

SELECT * FROM names WHERE username = '".addslashes("Oden'haran")."'

mayby something like this?

[tuppence]

look at addslashes()