On Tue, 18 Sep 2001 16:29:21 -0700 (PDT), John Holcomb wrote:
>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.
try error_reporting(15) at the top of the script. that might show you
what error you're getting.
> 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
>I know think my problem is that when I pass text to
>another page with the # sign, it's interpreting it as
well this might be true if you're eval()'ing the string...?
>Is their any way to somehow escape the # sign.
you don't have to, it's not a special character in mysql. try calling
mysql_error() after the query.
if you're still having trouble you can probably get more help on this
list if you post the relevant code, and the output from 'describe
$tablename' in mysql
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]