TOP TEN CHARTS IN SQL II

[Anon]

OK, mySQL displays the best 10 sold items in my site but... if the product repeats in the DB it displays it twice, I want mySQL to ignore it and search for the next one.

Get the idea?

Thank you folks

[Anon]

Try the option GROUP BY product_name or whatever field you don't want to repeat in the list.

Hope that helps.

Chris King

[Anon]

Isn't there something a little funny about your database
design-or at least the query--if you're getting items more
than once? What exactly is the query you are using?
And what do the tables look like?

[Anon]

Pepe,

In your SELECT statement, use SELECT DISTINCT. For example:

SELECT DISTINCT Itemname FROM TABLE WHERE UserID = '2A'

Of course, you would modify it for your needs, but that might work for you. If it doesn't, I believe I read somewhere that there might be an issue with the DISTINCT keyword and ORDER BY.

Hope this helps,

Joseph