Select DISTINCT with more than one column

[soltek]

Hey there, It'd be awesome if you could help me out with this:

 

What I'm trying to do is to select from the db all the new products of the day, BUT is there's 2 products with the same categorie, display only the last one.

Something like this:

SELECT id, date, txt, categorie FROM products WHERE date=$today AND [categorie is unique]

ORDER by date;

 

The part I'm having trouble with is the one between brackets.

Maybe this should be done in the loop, I've no idea.

 

Also I could use SELECT DISTINCT, but this wont allow me to select only the distincted column (categorie), right?

 

If you could give me a hand, it'd be awesome.

Thanks

 

[soltek]

Afterall I can use more than one column with DISTINCT, but this will give me the rows with different combinations between the columns, and since the id number is unique... jeez!

 

Is this impossible to do?

[soltek]

Here's an image to simplify the deal:

 

[Muddy_Funster]

if you only want to return a single entry for each catagory then:

SELECT MAX(id) AS id, date, txt, categorie FROM products WHERE date=$today GROUP BY categorie

 

 

[fenway]

Yeah, but that's scary, since you're returning non-aggregated values in the column list, which likely makes them meaningless.