<?php/*Hm.. Don't know why I made this... Will leave it for now in caseI 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 1 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 1 result. $row = mysql_fetch_object($result); $SBN['Name'] = $row->SName; $SBN['Genre'] = $row->SGenre; $SBN['Length'] = $row->SLength; $SBN['ArtistID'] = $row->SArtistID; $SBN['AlbumID'] = $row->SAlbumID; $SBN['ID'] = $row->SongID; return $SBN; } function _getSongByID($SongID) { $query = "SELECT * FROM mdbsongs WHERE SongID = '$SongID'"; $result = mysql_query($query); // No need for a loop, we will never get more then 1 result. $row = mysql_fetch_object($result); $SBID['Name'] = $row->SName; $SBID['Genre'] = $row->SGenre; $SBID['Length'] = $row->SLength; $SBID['ArtistID'] = $row->SArtistID; $SBID['AlbumID'] = $row->SAlbumID; $SBID['ID'] = $row->SongID; return $SBID; }}?>