public static function get_events_list_by_venue($venue)
{
$sql = "SELECT * FROM event WHERE event_venue = '{$venue}'";
$event_venue_query = mysqli_query(DataBucket::getConnection(), $sql);
$event_venue_bucket = mysqli_fetch_assoc($event_venue_query);
//return $event_venue_bucket;
do {
?>
<p>Event name: <?php
echo $event_venue_bucket['event_name'];
?>
at venue : <?php
echo $event_venue_bucket['event_venue'];
?>
</p>
<!--//WE CAN ALSO DISPLAY ALL OTHER FIELDS IN THE DB-->
<?php
} while ($event_venue_bucket = mysqli_fetch_assoc($event_venue_query));
//HOW TO USE DataBucket::get_events_list();
//return $get_event_id = $event_by_id_bucket['event_id'];
//$get_event_name = $event_by_id_bucket['event_name'];
//$get_event_content = $event_by_id_bucket['event_content'];
}
