PHP 4.0 Bug #9110: SELECT DISTINCT broken
| From: | karel at narfum dot org | Date: | Mon, 05 Feb 2001 14:03:09 +0000 |
| Subject: | PHP 4.0 Bug #9110: SELECT DISTINCT broken | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-45770@lists.php.net to get a copy of this message | ||
From: karel@narfum.org
Operating system: Linux 2.2.x
PHP version: 4.0.3pl1
PHP Bug Type: MySQL related
Bug description: SELECT DISTINCT broken
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.
--
Edit Bug report at: http://bugs.php.net/?id=9110&edit=1