<?php

class MDBMusic {
	public $artist;
	public $album;
	public $song;
	
	protected function _getSongsByArtist($artist) {
		$query = "SELECT * FROM mdb_artists, mdb_album, mdb_songs WHERE mdb_artist.Artist = '$artist' AND mdb_songs.SongArtistID = mdb_artist.ArtistID AND mdb_album.AlbumArtistID"
		$result = mysql_query($query);
		$i = 0;
		while($row = mysql_fetch_object($result)) {
			$SBA[$i]['Artist']							= $row->$Artist;
			$SBA[$i]['Artist']['Albums']				= $row->AlbumName;
			$SBA[$i]['Artist']['Albums']['SongName'] 	= $row->SongName;
			$SBA[$i]['Artist']['Albums']['SongLength']	= $row->SongLength;
			$SBA[$i]['Artist']['Albums']['SongGenre']	= $row->SongGenre;
			$i++;
		}
	}
}

?>