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']; }