[Resolved] Parsing Single Quotes

Dear All,

How do i parse Single Quotes into the db table, 'coz whenever i insert into the table it gives mySQL error 'coz the variable contains Single Quotes.

$query = "INSERT INTO ads (catid, comp, owner) VALUES ($sh, '$comp', '$owner')";
$result = mysql_query($query) or die("Query failed");

Now suppose if the variable "$owner" contains Mac Son's, while inserting, the query fails.

So how do i Insert Single Quotes into the Database.

Please Help
THanx

Remove the single quotes around the $owner variable and it should work fine. 😉

turn magic quotes on if you have access to the php.ini file or try addslashes()

Cgraz

addslashes converts a ' to \'
stripslashes converts \' to '

Is you want to (for some reason) add a string containing a slash manually, just type \'

insert into table (textfield) values ('Freddy\'s text')

Thank you superwormy, eduard & cgraz for the Help. It has solved my probs.