Non-VB query...

[steadicamop]

Originally Posted by Eikinskjaldi

put a group by in there.

SELECT album, artist, max(date_added) as 'date_added' FROM samdb.songlist group by album,artist ORDER BY date_added DESC LIMIT 10")

Not sure how there can be blank entires though.

That's a badly un-normalised data structure.
artist_table
artist_id name birthdate favourite_color

album_table
artist_id album_id album_name other_album_data

track table
album_id track_name track_length

Thanks, but that doesn't appear to do what I need it to ... it pulls the tracks from the album too -- I want it to just show the Artist of the Album (could be Various) and then the Album title -- just once for each album, not for each track, if you follow what I mean?

I do agree it's badly formatted in the database, I'm working on tidying this lot up!

Thanks for your help,

Jason