|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #27831 Problem with mssql_fetch_array
Submitted: 2004-04-02 00:32 UTC Modified: 2004-04-02 03:05 UTC
From: mhabr at sszn dot cz Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.3.5 OS: MS SBS 2003
Private report: No CVE-ID: None
 [2004-04-02 00:32 UTC] mhabr at sszn dot cz
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[].


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-02 02:18 UTC]
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.
 [2004-04-02 03:05 UTC] mhabr at sszn dot cz
Whats the number of that existing bug please?
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Feb 21 09:01:28 2024 UTC