#27831 [Opn->Bgs]: Problem with mssql_fetch_array

ID: 27831 Updated by: derick@php.net Reported By: mhabr at sszn dot cz -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: MS SBS 2003 PHP Version: 4.3.5 New Comment: Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. Already filed. Previous Comments: ------------------------------------------------------------------------ [2004-04-02 00:32:39] mhabr at sszn dot cz Description: ------------ I connect to ms sql server.When I use mssql_fetch_array and then i wonna get collumns values , every value has an additional space at its end. Thanks a lot Reproduce code: --------------- $query = mssql_query("SELECT id,email,password,name FROM users WHERE login='$login'"); $row = mssql_fetch_array($query); if (mssql_num_rows($query) != 0) { 1) echo '*'.md5($passwd).'*'; 2) echo '*'.$row["password"].'*'; first echo 1) shows something like *4sdfdsf6ddt* but echo 2) shows *4sdfdsf6ddt * ___ this space isnt needed. Expected result: ---------------- no space at the end of $row["column_name"] Actual result: -------------- additional space at the end of $row[]. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27831&edit=1