Other Applications 41

My Albums

$host =  localhost ;
$user =  U
SERNAME
 ;
$pass =  P
ASSWORD
 ;
$database =  music ;
$query = "SELECT album, artist, year, rating FROM albums ORDER BY artist";
if ($sqlConnection = mysql_connect($host, $user, $pass)) {
if (mysql_select_db($database, $sqlConnection)) {
if ($queryResult = mysql_query($query, $sqlConnection)) {
while ($album = mysql_fetch_array($queryResult)) {
albumRow($album);
}
mysql_free_result($queryResult);
} else {
sqlProblem("Cannot perform query $query.");
}
} else {
sqlProblem("Cannot select database $database.");
}
mysql_close($sqlConnection);
} else {
sqlProblem("Problem connecting to $host.");
}
function sqlProblem($warning) {
$latestError = mysql_error();
echo "$warning ($latestError)\n";
}
function albumRow($albumInfo) {
$album = $albumInfo[ album ];
$artist = $albumInfo[ artist ];
$year = $albumInfo[ year ];
$rating = $albumInfo[ rating ];
echo "\t\t\t";
echo "";
echo "\n";
}
?>

Album
Artist
Year
Rating

$album
$artist
$year
$rating