{$artist['name']}
"; if ($user->loggedin) { echo "Add this artist to your favorites list"; } echo "| Country | {$artist['country']} | |
| Genre | {$artist['genre']} |
Photos
| "; $loop = 0; $query = mysql_query("SELECT image.thumb AS thumb, image.name as imagename, user.name as username, user.id AS userid, concert.id AS concertid, city.name as city, country.name AS country FROM image JOIN (concert, artist, user, country, city) ON (image.user = user.id AND image.artist = artist.id AND image.concert = concert.id AND concert.city = city.id AND city.country = country.id) WHERE image.artist = '{$artist['id']}' ORDER BY image.date DESC"); while ($image = mysql_fetch_array($query)) { if ($loop == 4) { echo " |
| ";
$loop = 0;
}
echo "{$image['city']} - {$image['country']}, by {$image['username']}\" class='artist_album'> |
Comments
Post a comment
"; if ($user->loggedin) { echo "Posted comments
"; } $query = mysql_query("SELECT artist_comment.comment as comment, artist_comment.date AS date, user.name as username, user.id AS userid FROM artist_comment, user WHERE artist_comment.artist = '{$_GET['artist']}' AND user.id=artist_comment.user ORDER BY date DESC"); while($comment=mysql_fetch_array($query)) { echo "{$comment['username']} - {$comment['date']}
";
echo nl2br($comment['comment']);
echo "