GROUP BY order

corvinedesign

I have a gallery database that has a bunch of info

id type group date
1 photo pool 2003-08-09
2 art cat 2003-08-19
3 photo me 2003-08-01
4 art pool 2003-08-12
5 photo cat 2003-08-23
6 photo pool 2003-08-30
(all rows have a thumbnail image in the database also)

the first page lists the types so it gives two links one for art the other for photo and does not show any image, when you click on a link for a type of art it displays the type so for the photo link it would show all the photo entries here is my dilema.... right now it has SELECT * from gallery where type is like photo group by group, what it does is show the first entry in the group not the way I want it to. so for photo and the group being pool i want it to display the entry id = 6 as the thumb. now I thought maybe do this with and order command but that wont work. so what about an array,....I know nothing of arrays. if you want the example I can send the link if you ask. thanks

udendra

actualyy U got 2 rows that equal type=photo group=pool. so be more specific if u need to get the id=6 ... probably with the date.

EpicEro

Try using %.

SELECT * from gallery where type like '% photo% ' group by group

axo

the mode you work with the database is wrong:
using like will slow down the whole database for much.

try:

indexes on ids, timestmp cat_id and gal_id

querying for all categories:
SELECT id,timestmp,title,etc FROM categories

querying for all galleries in the category:
SELECT id,cat_id, timestp, title, etc FROM galleries WHERE cat_id = '1'

querying for pictures in the gallery:

SELECT id, cat_id, gal_id, timestmp, title, url FROM pictures WHERE cat_id = '1' AND gal_id ='2'

so you will be able to work much easier with the pictures, and mysql querying only for integer values will be about 100 times faster than the query for '%LIKE%' .

and NEVER use "SELECT *" because it's slower...