= '".date ( 'Y-m-d' )."' ORDER BY date(start_date)";
}else {
$sql = "SELECT * FROM " . $events_detail_tbl . " WHERE id = $event_id";
}
if (mysql_query($sql)){
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc ($result))
{
$event_id = $row['id'];
$event_name = stripslashes($row['event_name']);
$event_desc = stripslashes($row['event_desc']);
$display_desc = $row['display_desc'];
$event_description = stripslashes($row['event_desc']);
$event_identifier = stripslashes($row['event_identifier']);
$event_cost = $row['event_cost'];
$use_coupon_code = $row['use_coupon_code'];
$active = $row['is_active'];
$reg_limit = $row['reg_limit'];
$allow_multiple = $row ['allow_multiple'];
$start_time = $row['start_time'];
$end_time = $row['end_time'];
$start_date = $row['start_date'];
$end_date = $row['end_date'];
$reg_limit=$row['reg_limit'];
}
if ($reg_limit != ""){
if ($reg_limit > $num_attendees){
$available_spaces = $reg_limit - $num_attendees;
}else if ($reg_limit <= $num_attendees){
$available_spaces = 'EVENT FULL';
}
}
if ($reg_limit == "" || $reg_limit == " " || $reg_limit == "999"){$available_spaces = "Unlimited";}
//get attendee count
$events_attendee_tbl = get_option ( 'events_attendee_tbl' );
$sql= "SELECT SUM(quantity) FROM " . $events_attendee_tbl . " WHERE event_id='$event_id'";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
$num_attendees = $row['SUM(quantity)'];
}
if ($reg_limit == "" or $reg_limit >= "$num_attendees") {
if ($reg_limit == "" || $reg_limit == " "){
$reg_limit = 999;
}
if ($reg_limit <= $num_attendees){ ?>
We are sorry but this event has reached the maximun number of attendees!
Please check back in the event someone cancels.
Current Number of Attendees:
$num_attendees){
$available_spaces = $reg_limit - $num_attendees;
}
}
if ($reg_limit == "" || $reg_limit == " " || $reg_limit == "999"){$available_spaces = "Unlimited";}
?>
Start Date: - Start Time:
End Date: - End Time:
Description:
Cost
Spaces Available:
Event Registration and Ticketing Powered by Event Espresso
Sorry, this event has expired or is no longer available.