Hi!! I have this query in PHP: $items2 = mysql_query("SELECT DISTINCT * FROM rev ORDER BY rev", $link); I have three rows with the same data on it, and DISTINCT seems to be not working, since I got all the rows, any ideas of what is going wrong? -------------------------- MIGUEL GUIRAO AGUILERA Logistica R8 - Telcel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php