You are not logged in.

Saved favorites

Favorite genres

"; $query = mysql_query("SELECT genre.name, genre.id FROM user_genre JOIN (genre) ON (user_genre.genre = genre.id) WHERE user_genre.user = '{$user->id}'"); while ($genre = mysql_fetch_array($query)) { echo ""; } echo "

" . $genre['name'] . "

"; $query2 = mysql_query("SELECT id FROM artist WHERE added > '{$last_login}' AND genre = '{$genre['id']}'"); if (mysql_num_rows($query2) > 0) echo " New artists! "; $query2 = mysql_query("SELECT concert.id FROM concert JOIN (artist) ON (concert.artist = artist.id) WHERE concert.added > '{$last_login}' AND artist.genre = '{$genre['id']}'"); if (mysql_num_rows($query2) > 0) echo " New concerts! "; echo "

Delete

Favorite artists

"; $query = mysql_query("SELECT artist.id as artistid, artist.name as artistname, country.name as countryname FROM artist JOIN (user_artist,country) ON (artist.id = user_artist.artist AND country.id = artist.country) WHERE user_artist.user = {$user->id}"); while($artist = mysql_fetch_array($query)) { echo ""; } echo "

{$artist['artistname']} - {$artist['countryname']}

"; $query2 = mysql_query("SELECT id FROM concert WHERE added > '{$last_login}' AND artist = '{$artist['artistid']}'"); if (mysql_num_rows($query2) > 0) echo " New concert! "; $query2 = mysql_query("SELECT id FROM image WHERE date > '{$last_login}' AND artist = '{$artist['artistid']}'"); if (mysql_num_rows($query2) > 0) echo " New photo! "; $query2 = mysql_query("SELECT id FROM artist_comment WHERE date > '{$last_login}' AND artist = '{$artist['artistid']}'"); if (mysql_num_rows($query2) > 0) echo " New comment! "; $query2 = mysql_query("SELECT id FROM artist_extras WHERE added > '{$last_login}' AND artist = '{$artist['artistid']}'"); if (mysql_num_rows($query2) > 0) echo " Extras added! "; echo "

Delete

Favorite photographers

"; $query = mysql_query("SELECT user.id as id, user.name as name FROM user JOIN (user_photographer) ON (user_photographer.photographer = user.id) WHERE user_photographer.user = '{$user->id}'"); while($photographer = mysql_fetch_array($query)) { echo ""; } echo "

{$photographer['name']}

"; $query2 = mysql_query("SELECT id FROM image WHERE date > '{$last_login}' AND user = '{$photographer['id']}'"); if (mysql_num_rows($query2) > 0) echo " New photo! "; $query2 = mysql_query("SELECT id FROM user_comment WHERE date > '{$last_login}' AND user = '{$photographer['id']}'"); if (mysql_num_rows($query2) > 0) echo " New comment! "; $query2 = mysql_query("SELECT user FROM user_pres WHERE updated > '{$last_login}' AND user = '{$photographer['id']}'"); if (mysql_num_rows($query2) > 0) echo " Updated pres! "; $query2 = mysql_query("SELECT id FROM user_artist WHERE added > '{$last_login}' AND user = '{$photographer['id']}'"); $query3 = mysql_query("SELECT id FROM user_genre WHERE added > '{$last_login}' AND user = '{$photographer['id']}'"); $query4 = mysql_query("SELECT id FROM user_photographer WHERE added > '{$last_login}' AND user = '{$photographer['id']}'"); if (mysql_num_rows($query2) > 0 || mysql_num_rows($query3) > 0 || mysql_num_rows($query4) > 0) echo " New favorite! "; echo "

Delete

My photos

"; $query = mysql_query("SELECT image.thumb AS thumb, 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) WHERE image.user = '{$user->id}' ORDER BY image.date DESC"); $loop = 0; while ($image = mysql_fetch_array($query)) { if ($loop == 4) { echo "

"; $loop = 0; } echo "{$image['artistname']}, by {$image['username']}\" class='artist_album'>"; $loop++; } echo "

Upload concert photos

Choose artist Choose artist"; $query = mysql_query("SELECT * FROM artist ORDER BY name"); while($artist = mysql_fetch_array($query)) { $query1 = mysql_query("SELECT name FROM country WHERE id = '{$artist['country']}'"); $country = mysql_fetch_array($query1); echo "{$artist['name']} - {$country['name']}"; } echo " Choose concert Choose concert

Step 3 - choose photo

Add concert

"; if ($user->type > 2) { echo "Choose artist "; $query = mysql_query("SELECT artist.id AS id, artist.name AS name, country.name AS country FROM artist JOIN (country) ON (artist.country = country.id) ORDER BY artist.name, country.name"); while ($artist = mysql_fetch_array($query)) { echo "{$artist['name']}, {$artist['country']}"; } echo ""; } echo "Choose city "; $query = mysql_query("SELECT city.name AS name, city.id AS id, country.name AS country FROM city JOIN (country) ON (city.country = country.id) ORDER BY country.name, city.name"); while ($city = mysql_fetch_array($query)) { echo "{$city['name']} - {$city['country']}"; } echo " Date

Add artist

Name Choose country "; $query = mysql_query("SELECT * FROM country ORDER BY name"); while ($country = mysql_fetch_array($query)) { echo "{$country['name']}"; } echo " Choose genre "; $query = mysql_query("SELECT * FROM genre ORDER BY name"); while ($genre = mysql_fetch_array($query)) { echo "{$genre['name']}"; } echo "