<?php
include_once( 'includes/php_vars.inc');

$db_return = @mysql_connect($host, $user, $password);
if ($db_return) {
mysql_select_db($database);
$query = "SELECT id, event_date, event_title, genre_id, artist_id, event_pic_link FROM calendar WHERE artist_id > 1 AND display = 1 AND (event_date >= Now()) OR (event_end_date >= DATE_ADD(Now(), INTERVAL 30 DAY)) ORDER BY event_date, event_time ASC";
//$query = "SELECT event_date, event_title, genre_id FROM calendar";// WHERE artist_id > 1"; //AND display = 1 AND (event_date >= DATE_ADD(Now(), INTERVAL 30 DAY) AND event_date <= DATE_ADD(Now(), INTERVAL 60 DAY)) OR (event_end_date >= DATE_ADD(Now(), INTERVAL 30 DAY) AND event_end_date <= DATE_ADD(Now(), INTERVAL 60 DAY)) ORDER BY event_date, event_time ASC";
$result = mysql_query($query);	
$array_count = mysql_num_rows($result);
$i = 0;
while($row = mysql_fetch_assoc($result)){
$allrows[$i] = $row;	
$i++;	
}

//$query = "SELECT id, genre_id FROM genre";
//$result2 = mysql_query($query);	
//$array_count2 = mysql_num_rows($result2);
//while($row2 = mysql_fetch_assoc($result2)){
//$genre[$row2['id']] = $row2['genre_id'];	
//}
if ($array_count > 10){
$counter = 10;
}else{
$counter = $array_count;
}
$link = "tcan_artistdetail.php";	
for($i = 0; $i < $counter; $i++){
$event_date[$i] = date("D M d, Y", strtotime($allrows[$i]['event_date']));
$event_title[$i] = $allrows[$i]['event_title']; 
$event_id[$i] = $allrows[$i]['id'];
$artist_id[$i] = $allrows[$i]['artist_id'];
$event_pic_id[$i] = $allrows[$i]['event_pic_link'];	
$genre[$i] = $allrows[$i]['genre_id'];	
}
for($i = 0; $i < $counter; $i++){
$query = "SELECT genre_id FROM artist WHERE id = $artist_id[$i]";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);	
$genre[$i] = $row['genre_id'];
}	
for($i = 0; $i < $counter; $i++){
if ($genre[$i] > 1){
$query = "SELECT genre_id FROM genre WHERE id = $genre[$i]";
$result = mysql_query($query);
$array_count = mysql_num_rows($result);
$row = mysql_fetch_assoc($result);
$genre[$i] = $row['genre_id'];
}	
}	

}
?>