SQL statement cannot detect special char

[Anon]

Hello,

I have a problem where the SQL statement cannot detect special characters.  Every time I add a user to my user table with the job title field as, lets say, "I'm a PHP developer", it makes mySQL act weird.  I cannot retrieve it from my edit user forms even if i ask to retrieve it from the exact userid, anyone know what the problem could be?

Will

[brandonschnell]

are you doing something like this:

/******** ADD USER **********/
$user = "I'm a PHP developer";
/add slashes to make the string kosher for PHP & SQL*/
$user = addslashes($user);

mysql_db_query("database","INSERT INTO table SET user = '$user'");

use something similiar to retreive the user.

also be sure the username is in the table
and is what you expect it to be.