if ($artistCount > $PREVIEW_COUNT) {
$random = mt_rand(0, $artistCount - $PREVIEW_COUNT);
} else {
$random = 0;
}
$artistQuery = "SELECT * FROM " . getJoinTable("artist_list", "artist_artwork_list") . " \n WHERE " . getJoinMatch("artist_list", "artist_artwork_list", "artist_id") . " AND " . getImageType($IMAGE_SIZE1) . " LIMIT " . $random . ", " . $PREVIEW_COUNT;
$artistResult = $dbHandle->query($artistQuery);
//
$albumCountResult = $dbHandle->query("SELECT * FROM album_list");
$albumCount = $albumCountResult->num_rows;
if ($albumCount > $PREVIEW_COUNT) {
$random = mt_rand(0, $albumCount - $PREVIEW_COUNT);
} else {
$random = 0;
}
$albumQuery = "SELECT * FROM " . getJoinTable("album_list", "album_artwork_list") . " \n WHERE " . getJoinMatch("album_list", "album_artwork_list", "album_id") . " AND " . getImageType($IMAGE_SIZE1) . " LIMIT " . $random . ", " . $PREVIEW_COUNT;
$albumResult = $dbHandle->query($albumQuery);
//
$trackCountResult = $dbHandle->query("SELECT * FROM track_list");
$trackCount = $trackCountResult->num_rows;
if ($trackCount > $PREVIEW_COUNT) {
$random = mt_rand(0, $trackCount - $PREVIEW_COUNT);
} else {
$random = 0;
}
$trackQuery = "SELECT * FROM track_list LIMIT " . $random . ", " . $PREVIEW_COUNT;
$trackResult = $dbHandle->query($trackQuery);
//
?>
<a id="topofpage"></a>
include 'header.php';
// Checks if the artist name has been submitted
if (!($artistName = getReqArtist())) {
$noInput = true;
} else {
$noInput = false;
}
// Gets the artist info //
if (!$noInput) {
$artistInfo = getSingleRow($dbHandle, "artist_list", "artist_name", $artistName);
$artResult = $dbHandle->query("SELECT * FROM artist_artwork_list WHERE artist_id='" . $artistInfo['artist_id'] . "' AND image_size='" . $IMAGE_SIZE5 . "'");
$artReturn = $artResult->fetch_array(MYSQLI_BOTH);
}
// Constructs the query to get both album info and artwork //
$albumQuery = "SELECT * FROM " . getJoinTable("album_list", "album_artwork_list") . " \n WHERE " . getJoinMatch("album_list", "album_artwork_list", "album_id") . " \n AND " . getImageType($IMAGE_SIZE3) . " \n AND " . getSectionCriteria("album_title");
if (!$noInput) {
$albumQuery .= " AND album_list.artist_id='" . $artistInfo['artist_id'] . "'";
}
$albumQuery .= " " . getSortCriteria("album_title");
// Gets the number of albums //
$totalResult = $dbHandle->query($albumQuery);
$totalCount = $totalResult->num_rows;
mysqli_free_result($totalResult);
$albumQuery .= " " . getPageCriteria($totalCount, $MAX_ITEMS_PER_PAGE, true);
$albumResult = $dbHandle->query($albumQuery);
?>
<a id="topofpage"></a>
<div id="content">
