php.net |  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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
42 + 49 = ?
Subscribe to this entry?

 
 [2004-04-02 00:32 UTC] 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[].

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-02 02:18 UTC] derick@php.net
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: Fri Apr 26 04:01:30 2024 UTC