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 ge

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-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 = > stripslashes(mysql_escape_string($HTTP_POST_VARS[

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 tr

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 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 any

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 electroteque
L PROTECTED] Subject: [PHP] 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

[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 Mailin