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
>a comment.

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]

Reply via email to