Re: Is there no one who can help me out there.

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 >issue. > >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