select distinct problem

[edgy]

Why does the following not return the results I want?

Code:
SELECT DISTINCT(Host),Category,SubCategory,Click,Date
,HRef,HeadLine,ID FROM artiklar WHERE Category = 'Cars' AND SubCategory = 'Mitsubishi' AND Host <> 'www.mitsubishimotors.com' ORDER BY ID DESC LIMIT 5

I want to return a list of the five lates articles about Mitsubishi cars, where www.mitsubishimotors.com isn't the source (Host) and I only want max 1 article from any Host.

What I'm getting is the five latest articles, not from mitsubibushimotors.com, but from the same host (if articles from that host have the highest ID in the database).

How can I make this work? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[hannah]

It doesn't work because DISTINCT is not a function that works on a single column like you are trying to do, it works across an entire row of columns that you have selected. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --