It's a MySQL issue, probably.

Addslashes() should take care of it, I think...
If not, find out how MySQL escapes # and use http://php.net/str_replace

--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out?  Like Music?  Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: John Holcomb <[EMAIL PROTECTED]>
Newsgroups: php.general
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 18, 2001 3:36 PM
Subject: Help with escaping the # sign


> I have a text input field in my form.  I need the user
> to be able to enter something like:  Hello, I need #
> help. After which they click on a submit button.   The
> succeeding page then takes this text and tries to
> display it and tries to store "Hello, I need # help"
> in a varchar field in a mysql table column.   The
> mysql database is truncating the # sign and the text
> succeeding the # sign.  Also, absolutly no text is
> being diplayed on the succeeding web page.  I've tried
>  using addslashes() and I was warned against using
> htmlentities().  Also, I'm not sure if I'm dealing
> with 2 issues: A mysql issue and a html issue. Or, am
> I dealing with one issue: A mysql issue or an HTML
> issue.
>
>   Thank you,
>
> John
>
> __________________________________________________
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Information/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to