PHP :: Bug #9110 :: SELECT DISTINCT broken

Bug #9110	SELECT DISTINCT broken
Submitted:	2001-02-05 09:03 UTC	Modified:	2001-02-05 09:05 UTC
From:	karel at narfum dot org	Assigned:
Status:	Not a bug	Package:	MySQL related
PHP Version:	4.0.3pl1	OS:	Linux 2.2.x
Private report:	No	CVE-ID:	None

View Developer Edit

[2001-02-05 09:03 UTC] karel at narfum dot org

A simple query as this one complety ignores the DISTINCT statement:

"SELECT DISTINCT opponent,opponent_url FROM wars WHERE (opponent_url <> '' AND opponent_url <> 'http://' ) AND played='1' ORDER BY opponent,opponent_url"

I've searched this site and google.com for solutions for it, but php.net showed nothing and google had only more people reporting the same problem. I searched the bug database and didn't fin anything matching 'DISTINCT'. So this is my bugreport.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports

[2001-02-05 09:05 UTC] derick@php.net

This has nothing to do with PHP, take a look at the MySQL documentation

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2025 The PHP Group All rights reserved.	Last updated: Sun Mar 16 02:01:28 2025 UTC