Not displaying all data from row

[bugsuperstar37]

I have a PHP page that queries a data base and displays the data in a HTML form. It is using straight forward SQL calls.

The only problem I have is that some of the variables do not display all the data that is parsed from the column. I have no idea why. The column is a longtext, I have other columns that are longtext that display all the data that they hold. There is no certain character that stops it. What could cause this and what should I attempt to fix this?

Chris

[Anon]

Try using the function addslashes() to all strings you are entering to the db. This will escape the bad chars.
Example
$newstring=addslashes($oldstring);

use the stripslashes() for data taken to display from the db

[bugsuperstar37]

I don't know if the function would solve this problem, but please let me know if you think it will. The problem seems to be any double space in the field that is queried stops the rest of the data from being parsed. If I remove the double space and make them a single space, it works great.

Chris