get_results($sql)){
$events = $wpdb->get_results($sql);
foreach ($events as $event){ //These are the variables that can be used throughout the regsitration page
$event_id = $event->id;
$event_name = stripslashes_deep($event->event_name);
$event_desc = stripslashes_deep($event->event_desc);
$display_desc = $event->display_desc;
$event_address = $event->address;
$event_address2 = $event->address2;
$event_city = $event->city;
$event_state = $event->state;
$event_zip = $event->zip;
$event_country = $event->country;
$event_description = stripslashes_deep($event->event_desc);
$event_identifier = $event->event_identifier;
$event_cost = empty($event->event_cost) ? 0 : $event->event_cost;
$member_only = $event->member_only;
$active = $event->is_active;
$reg_limit = $event->reg_limit;
$allow_multiple = $event->allow_multiple;
$start_date = $event->start_date;
$end_date = $event->end_date;
$reg_limit=$event->reg_limit;
$additional_limit = $event->additional_limit;
$regurl=espresso_reg_url($event_id);
$google_map_link = espresso_google_map_link(array( 'address'=>$event_address, 'city'=>$event_city, 'state'=>$event_state, 'zip'=>$event_zip, 'country'=>$event_country) );
}//End foreach ($events as $event)
}
?>
|