From: [EMAIL PROTECTED] 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 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]