<?php

/*

Hm.. Don't know why I made this... Will leave it for now in case
I find a good use for it.

class MDBMusic {
}

*/

class Artist {
	public $Artist;
	public $ArtistID;
	
	function _getArtistByName($Artist) {
		$query = "SELECT * FROM mdbartists WHERE Artist = '$Artist'";
		$result = mysql_query($query) or die(mysql_error());
		// No need for a loop, we will never get more then 1 result.
		$row = mysql_fetch_object($result);
		$ABN['Artist']		= $row->Artist;
		$ABN['ArtistID']	= $row->ArtistID;
		return $Art;
	}
	
	function _getArtistByID($ArtistID) {
		$query = "SELECT * FROM mdbartists WHERE ArtistID = '$ArtistID'";
		$result = mysql_query($query) or die(mysql_error());
		// No need for a loop, we will never get more then 1 result.
		$row = mysql_fetch_object($result);
		$ABID['Artist']		= $row->Artist;
		$ABID['ArtistID']	= $row->ArtistID;
		return $ABID;
	}
}

class Albums {
	public $AlbumName;
	public $AlbumID;
	public $Artist;
	
	function _getAlbumByName($AlbumName) {
		$query = "SELECT * FROM mdbalbums WHERE AlbumName = '$AlbumName'";
		$result = mysql_query($query) or die(mysql_error());
		// No need for a loop, we will never get more then result.
		$row = mysql_fetch_object($result);
		$ABN['Name']		= $row->AlbumName;
		$ABN['Date']		= $row->AlbumDate;
		$ABN['Type']		= $row->AlbumType;
		$ABN['NumSongs']	= $row->AlbumNumSongs;
		$ABN['ArtistID']	= $row->AlbumArtistID;
		$ABN['ID']			= $row->AlbumID;
		return $ABN;
	}
	
	function _getAlbumsByArtist($Artist) {
		$query = "SELECT * FROM mdbartist, mdbalbums WHERE mdbartists.Artist = '$Artist' AND mdbalbums.AArtistID = mdbartists.ArtistID";
		$result = mysql_query($query) or die(mysql_error());
		$i = 0;
		while($row = mysql_fetch_object($result)) {
			$ABA[$i]['Artist']		= $row->Artist;
			$ABA[$i]['AlbumName']	= $row->AName;
			$ABA[$i]['AlbumID']		= $row->AlbumID;
			$ABA[$i]['AlbumArtist']	= $row->AArtistID;
			$i++;
		}
		return ABA;
	}
	
}

class Songs {
	public $SongName;
	public $SongID;
	
	function _getSongByName($SongName) {
		$query = "SELECT * FROM mdbsongs WHERE SongName = '$SongName'";
		$result = mysql_query($query);
		// No need for a loop, we will never get more then result.
		$row = mysql_fetch_object($result);
		$SBN['Name']		= $row->SongName;
		$SBN['Genre']		= $row->SongGenre;
		$SBN['Length']		= $row->SongLength;
		$SBN['ArtistID']	= $row->SongArtistID;
		$SBN['ID']			= $row->SongID;
		return $SBN;
	}
	
}

?>