stockton Posted September 30, 2009 Share Posted September 30, 2009 I have the following code that is adding a space character to the string extracted from a postgresql database $SQL = 'SELECT * FROM "Primary"."Help" WHERE "TopicID" = '.$ID; $qw = $DBConnection->query($SQL); $RowCounter = $qw->numRows(); while($Row = $qw->fetchRow(DB_FETCHMODE_ASSOC)) { $RecordType = $Row['TopicID']; $TopicName = $Row['TopicName']; $Topic = html_entity_decode($Row['TopicBody']); $Parent = $Row['Parent']; if ($Parent == 0) $ParentString = 'Parent'; else $ParentString = 'Dependant'; } When the string is 1st inserted into the database it is fine and on subsequent reads it is fine using the following code. $query='SELECT "TopicBody" FROM "Help" WHERE "TopicID"='.$term.';'; $qw = $DBConnection->query($query); $RowCounter = $qw->numRows(); if($RowCounter==0) { echo "No record found"; } else{ $Row = $qw->fetchRow(DB_FETCHMODE_ORDERED); echo html_entity_decode($Row[0]); } Please tell me what is different. Quote Link to comment Share on other sites More sharing options...
cags Posted September 30, 2009 Share Posted September 30, 2009 You don't show any output code in the first example. Are you sure your not outputting a space accidently before the variable? Quote Link to comment Share on other sites More sharing options...
stockton Posted September 30, 2009 Author Share Posted September 30, 2009 Thanks for the suggestion and I will check it. Quote Link to comment Share on other sites More sharing options...
stockton Posted September 30, 2009 Author Share Posted September 30, 2009 The error was not in the php but rather in the html were I had a line reading <td><textarea cols="60" rows="10" id="TopicBody" name="TopicBody"> <?php echo "$Topic" ?> rather than <td><textarea cols="60" rows="10" id="TopicBody" name="TopicBody"><?php echo "$Topic" ?> Spot the additional space....:-( My bad. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.