More Info Coming Soon…

$main_cat = “10″;
$sub_cat = “7″;
$venue_name = “XS Nightclub”;
echo’

‘.$venue_name.’ Upcoming Events

‘;
$result = @mysql_query(”Select * FROM events WHERE date > “.time().” AND subcategory = ‘”.$sub_cat.”‘ AND category = ‘”.$main_cat.”‘ ORDER BY date ASC LIMIT 5″);
while ( $row = mysql_fetch_array($result) ) {
extract($row);
echo ““.$title. “ “. date(’m-d-y’, $date). “”;
echo ”

“;
}
?>

Add a Review”;
?>

Reviews -

$result = @mysql_query(”Select * FROM venue_reviews WHERE venue_id = ‘”.$sub_cat.”‘ AND main_cat = ‘”.$main_cat.”‘ AND approved = ‘1′ ORDER BY id ASC LIMIT 5″);
while ( $row = mysql_fetch_array($result) ) {
extract($row);
echo “Review posted by: “;
if($folder == “”) {
echo $name;
echo ”
Venue Rating:”;
} else {
echo”“.$name.”
Venue Rating: “;
}
if($stars == “1″) {
echo’ A total of ‘.$stars.’ out of 5 Bottles’;
} else if($stars == “2″){
echo’ A total of ‘.$stars.’ out of 5 Bottles’;
} else if($stars == “3″) {
echo’ A total of ‘.$stars.’ out of 5 Bottles’;
} else if($stars == “4″){
echo’ A total of ‘.$stars.’ out of 5 Bottles’;
} else if($stars == “5″){
echo’ A total of ‘.$stars.’ out of 5 Bottles’;
} else {
echo “No Rating”;
}
echo ”

Review: “.$review;
echo ”

“;
}
?>