I have the following code that inserts data into a MySQL database.

PHP Code:

$gal_name_insert = mysql_real_escape_string($_POST['txt_name']);
mysql_query("INSERT INTO galleries (gal_name)VALUES (\"$gal_name_insert\"); 


When It gets inserted to my local database it shows like

PHP Code:

Best for you best for your pet \"New\" 


This is how I would expect it to be inserted. I would then use

PHP Code:

stripslashes 


on the display page.

When I use the same inset code on my live server it gets inserted without the slashes

PHP Code:

Best for you best for your pet "New" 


Is there a setting or something that strips the slashes on inserting?

Cheers

Wayne

PHP Code:

$gal_name_insert = mysql_real_escape_string($_POST['txt_name']);
mysql_query("INSERT INTO galleries (gal_name) VALUES ('$gal_name_insert')"; 


This is pesky, stupid magic quotes at work here. Happens to me ALL the time. The easiest solution is to use this code to disable it at runtime, or you could just disable it serverside, which is the example above the one in the link.

Cheers Physicsguy,

It was magic_quotes. I've turned them off in the php.ini file.