Welcome to Live Shots
This is a page for music entusiasts and both regular and iregular concert visitors who wants to share their enjoyments and experienses.
The toplists of today
The latest Photos
"; #hämta från db //db image behöver date och anropet behöver join med artist så man kan få ut namnet $query = mysql_query("SELECT image.name as imagename, user.name as username, user.id AS userid, artist.id AS artistid, artist.name as artistname FROM image JOIN (concert, artist, user) ON (image.user = user.id AND image.artist = artist.id AND image.concert = concert.id) ORDER BY image.date DESC LIMIT 10"); echo "- ";
$count = 10;
while($image = mysql_fetch_array($query)) {
//eventuelt en sida för att visa bilder på
echo "
- {$image['artistname']}, by {$image['username']}\">{$image['artistname']}, Photo: {$image['username']} "; $count--; } for($i = 0; $i < $count; $i++) { echo "
- N/A "; } echo "
Most commented Concerts
"; #hämta från db //eventuel comenterings räknare i db, i anropet eller en funktion //och join för att få fram användare och artist $query = mysql_query("SELECT concert.id, concert.date, artist.name as artistname, concert.comments, city.name as city FROM concert JOIN (artist, city) on (concert.artist = artist.id AND city.id = concert.city) WHERE concert.comments > 0 ORDER BY comments DESC LIMIT 10"); $count = 10; echo "- ";
while($concert = mysql_fetch_array($query)) {
//eventuelt en sida för att visa comments på
echo "
- {$concert['city']}: {$concert['artistname']}-{$concert['date']}: {$concert['comments']} "; $count--; } for($i = 0; $i < $count; $i++) { echo "
- N/A "; } echo "
Upcoming Concerts
"; #hämta från db $date = date("Y\-m\-d");//somthing like: 2008-11-01 /*fixa join if($loggedin) { $query = mysql_query("SELECT * FROM concerts WHERE date >= {$date} && country = {$user.country} ORDER BY date LIMIT 10");//inte korekt } else { }*/ $query = mysql_query("SELECT concert.id as id, artist.name as name, concert.date as date, city.name as city, country.name as country FROM concert JOIN (artist, city, country) on (concert.artist = artist.id AND city.id = concert.city AND city.country = country.id) WHERE concert.date >= CAST(NOW() as DATE) ORDER by date ASC LIMIT 10");//vet inte om det funkar $count = 10; echo "- ";
while($concert = mysql_fetch_array($query)) {
echo "
- {$concert['city']}: {$concert['name']}-{$concert['date']} "; $count--; } for($i = 0; $i < $count; $i++) { echo "
- N/A "; } echo "
Most commented Artist
"; #hämta från db //eventuel comenterings räknare i db, i anropet eller en funktion //och join för att få fram användare och artist $query = mysql_query("SELECT * FROM artist WHERE comments > 0 ORDER BY comments DESC LIMIT 10"); $count = 10; echo "- ";
while($artist = mysql_fetch_array($query)) {
//eventuelt en sida för att visa comments på
echo "
- {$artist['name']}: {$artist['comments']} "; $count--; } for($i = 0; $i < $count; $i++) { echo "
- N/A "; } echo "