Hello everyone,

This was posted in the PHP section also...

I have a MSSQL db with PHP front end.
The data in the table is similiar to:

"Two spaces" with 2 white spaces in the middle.

When I use this code:

$sql = "select Name FROM Name_TBL WHERE Number = '$Num"; 
$rs = mssql_query($sql); 
$RT = mssql_fetch_array($rs); 
$Name= $RT[Name'];

In the DB, and when I use another query analyzer, I get the correct return of "Two spaces" with 2 white spaces in the middle.

BUT...in PHP when I echo $Name, one of the two spaces has been deleted.
So I echo "Two spaces" with 1 white spaces in the middle.
I need the varchar to be exactly like it is in the DB, and I CANNOT change the data to one space.

Does anyone know what is causing this? Is there someting in the php.ini file that would do this?

PLEASE HELP I AM STUCK!!

-Joe