Re: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-09 Thread John W. Holmes
Vernon wrote: I know that using stripslashes will remove \ using php but I'm having trouble with posting quotation marks in a text record field. Anyone know how I can get them to post to the database? It's basically like an email and I'd like anything written to be able to post. Use htmlentities()

RE: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-09 Thread electroteque
To: Vernon Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Text boxes posted to MySQL record that contain quotes Vernon wrote: I know that using stripslashes will remove \ using php but I'm having trouble with posting quotation marks in a text record field. Anyone know how I can get them to post

[PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread Vernon
I know that using stripslashes will remove \ using php but I'm having trouble with posting quotation marks in a text record field. Anyone know how I can get them to post to the database? It's basically like an email and I'd like anything written to be able to post. Thanks -- PHP General

RE: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread electroteque
] Text boxes posted to MySQL record that contain quotes I know that using stripslashes will remove \ using php but I'm having trouble with posting quotation marks in a text record field. Anyone know how I can get them to post to the database? It's basically like an email and I'd like anything

RE: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread electroteque
apologies i hope it didnt look like i just hijacked the thread i was just adding to it, this is a pretty serious issue though i dont think i've ever come across it before funny enough as most the quoted text is in the textarea instead , the quik fix i've done is to remove the quotes altogether but

Re: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread Burhan Khalid
On Wednesday, July 9, 2003, 5:50:05 AM, Vernon wrote: V I know that using stripslashes will remove \ using php but I'm having V trouble with posting quotation marks in a text record field. Anyone know how V I can get them to post to the database? It's basically like an email and I'd V like

RE: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread electroteque
adding slashes doesnt work like i said all that will show up in the box is a slash \ Try mysql_escape_string() -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread Vernon
OK when I use the mysql_escape_string() it adds the slashes so that the message will have \the message\ so I've tried using the stripslashes() as such: $message = stripslashes(mysql_escape_string($HTTP_POST_VARS['message'])); which then causes the orginal problem, so it seems that I keep

Re: [PHP] Text boxes posted to MySQL record that contain quotes

2003-07-08 Thread gamin
Vernon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] OK when I use the mysql_escape_string() it adds the slashes so that the message will have \the message\ so I've tried using the stripslashes() as such: $message =