Apostrophe won't escape properly

[PinFX]

$current_user_fullname = "Bill O\'Connor";

$sql = "INSERT INTO users_list (username) 
	VALUES ('$current_user_fullname') ";

When I run this code its as if it doesn't escape at all, but the backslash disappears.

Error message is basically:

Incorrect syntax near 'Connor'. (severity 15)

[piersk]

try [man]addslashes()[/man] as in this:

$current_user_fullname = addslashes("Bill O'Connor");