public function load($iRecordID)
{
$oCon = new connection();
$sSQL = "SELECT RecordID, Title, Artist, Price, GenreID, PhotoPath\n\t\t\t\tFROM tbrecords \n\t\t\t\tWHERE RecordID = " . $iRecordID;
$oResultSet = $oCon->query($sSQL);
$aRow = $oCon->fetchArray($oResultSet);
$this->iRecordID = $aRow['RecordID'];
$this->sTitle = $aRow['Title'];
$this->sArtist = $aRow['Artist'];
$this->fPrice = $aRow['Price'];
$this->iGenreID = $aRow['GenreID'];
$this->iPhotoPath = $aRow['PhotoPath'];
$oCon->close();
}
