I am trying to get a set of data to display like this:
Release Date: release date
List of Songs
I basically want a self-containted table setup for each album. This is the query I am running:
SELECT album_list.title, path_to_cover, release_date, song_list.id, song_list.title FROM album_list, song_list
The problem I am having is that when the page loads, it spits out 3 sets of the text "Album Title, Release Date etc" (3 using this example) I only want it to show one album title, one release date and one cover. I know that I have done this before, buti for some reason I cannot get my mind around it right now.