Re: MySQL Double Quotes Problem(")

I have not gotten a single error showing up while running this code, and it can't be a problem with the output routine, because when I go into phpmyadmin and actually check the values of the table, the 'content' column will always be blank following the first double quote.

My Website
Get Eated!

Comment on Re: MySQL Double Quotes Problem(")

Replies are listed 'Best First'.
Re^2: MySQL Double Quotes Problem(") by injunjoel (Priest) on Dec 20, 2005 at 19:19 UTC
Greetings, If you are using phpmyadmin you are limited by HTML for display and PHP for dealing with the quotes when the come back out of your database. My thoughts are that the problem is somewhere between PHP and HTML. Looking at the page source to see if the value is the same as what is being displayed would be a good first step (is it truncated in the source as well?), but I would suggested using the tools that come with mysql (Im talking command line) to validate that the double quotes are truncating the values being inserted. Normally if it is and issue with quotes being inserted, be them single or double, then DBI or the corresponding DBD will warn you about that. Just a thought. -InjunJoel "I do not feel obliged to believe that the same God who endowed us with sense, reason and intellect has intended us to forego their use." -Galileo	[reply]
Re^2: MySQL Double Quotes Problem(") (input) by tye (Sage) on Dec 24, 2005 at 19:36 UTC
Actually, my guess was that is was a problem with how you get the input. Not getting errors reinforces the conclusion that it isn't an SQL problem and is consistent with the problem being with how you get input. - tye	[reply]