PHP 4.0 Bug #9110 Updated: SELECT DISTINCT broken

ID: 9110 Updated by: derick Reported By: karel@narfum.org Old-Status: Open Status: Bogus Bug Type: MySQL related Assigned To: Comments: This has nothing to do with PHP, take a look at the MySQL documentation Previous Comments: --------------------------------------------------------------------------- [2001-02-05 09:03:09] karel@narfum.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. --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9110&edit=2