Re: display a single thumb per gallery
| From: | Frank Arensmeier | Date: | Mon, 28 Aug 2006 22:03:30 +0000 |
| Subject: | Re: display a single thumb per gallery | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-241163@lists.php.net to get a copy of this message | ||
http://dev.mysql.com/doc/refman/5.0/en/join.html
you could use something like this:
SELECT DISTINCT thumbnails.gallery, thumbnails.id, thumbnails.binary_data FROM thumbnails
you can insert everything you want from your table after the DISTINCT by writing:
table.colName
/frank
27 aug 2006 kl. 21.39 skrev <ross@aztechost.com> <ross@aztechost.com>:
$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?