#30322 [NEW]: mssql_fetch_field(result)->column_source same as ->name

From: Date: Mon, 04 Oct 2004 14:22:23 +0000
Subject: #30322 [NEW]: mssql_fetch_field(result)->column_source same as ->name
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-67083@lists.php.net to get a copy of this message
From: erik at xpand dot nl Operating system: Windows Server 2003 PHP version: 5.0.2 PHP Bug Type: MSSQL related Bug description: mssql_fetch_field(result)->column_source same as ->name Description: ------------ I executed this query with 2 columns which have the same name: SELECT tbl1.n_MatchID, tbl2.n_MatchID FROM tbl1,tbl2 WHERE (etc) When I request the fields, the column_source and the name are the same... Reproduce code: --------------- $query = "SELECT Infostrada.tFootballMatch.n_MatchID as a, Infostrada.tFootballMatchDetail.n_MatchID as b FROM Infostrada.tFootballMatchDetail, Infostrada.tFootballMatch WHERE Infostrada.tFootballMatch.n_MatchID = Infostrada.tFootballMatchDetail.n_MatchID"; $result = mssql_query($query) or die(); while($obj = mssql_fetch_field($result)) { echo $obj->column_source . "." . $obj->name . "<br>"; } Expected result: ---------------- tFootballMatch.n_MatchID<br> tFootballMatchDetail.n_MatchID<br> ($obj->column_source.$obj->name) Actual result: -------------- n_MatchID.n_MatchID<br> n_MatchID.n_MatchID<br> -- Edit bug report at http://bugs.php.net/?id=30322&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30322&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30322&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30322&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30322&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30322&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30322&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30322&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30322&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30322&r=support Expected behavior: http://bugs.php.net/fix.php?id=30322&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30322&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30322&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30322&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30322&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30322&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30322&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30322&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30322&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30322&r=mysqlcfg

« previous php.bugs (#67083) next »