$query = "SELECT distinct gallery FROM thumbnails"; that only returns the numbers 7 & 8. I need the all the info from the rows - id, binary data etc....something like $query = "SELECT * FROM DISTINCT gallery FROM thumbnails"; any ideas? ----- Original Message ----- From: Dave Goodchild To: Ross Cc: php-general@xxxxxxxxxxxxx Sent: Sunday, August 27, 2006 8:21 PM Subject: Re: display a single thumb per gallery To find out how many unique galleries: SELECT DISTINCT gallery FROM table Ross -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- http://www.web-buddha.co.uk http://www.projectkarma.co.uk