ID: 9110 Updated by: derick Reported By: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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 -- 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]