[SOLVED] html_entity_decode adding a space in 1st position

[stockton]

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.

 

[cags]

You don't show any output code in the first example. Are you sure your not outputting a space accidently before the variable?

[stockton]

Thanks for the suggestion and I will check it.

[stockton]

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.