timjpriebe — Mon, 28 Aug 2006 13:54:00 +0000

You need to delete the *. That won't really even logically work with the distinct statement, but if you really want to display any other fields, you'll have to list them out specifically.

sublimer — Sun, 27 Aug 2006 01:15:50 +0000

thanks, i had my punction wrong. i remeber needing to inlcude DISTINCT.

this is what i had before your correction!

$sql = "SELECT DISTINCT 'artist' * FROM downloads WHERE filetype='video' ORDER BY artist ASC";

thanks alot Greg K
-drew

Greg K — Sun, 27 Aug 2006 01:07:03 +0000

There was an error is your SQL statemtent when I visited the page, so I couldn't see what you were talking about, however, if I am understanding you correctly, what you are wanting in the DISTINCT option to select only unique entries (remove duplicates).

Just guessing based on the error I'm given on your page, you would want something similar to this:SELECT DISTINCT `artist` FROM `downloads` WHERE `filetype`='video' ORDER BY `artist`'See http://dev.mysql.com/doc/refman/5.0/en/select.html for more info.

-Greg