Sports Professionals

get_col( $wpdb->prepare( " SELECT DISTINCT pm.meta_value FROM {$wpdb->postmeta} pm LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id WHERE pm.meta_key = '%s' AND p.post_status = '%s' AND p.post_type = '%s' ORDER BY pm.meta_value ASC ", $key, $status, $type ) ); return $r; } $meta_values = get_meta_values( 'Discipline' ); if( !empty( $meta_values ) ) { $meta_counts = array(); foreach( $meta_values as $meta ) $meta_counts[] = $meta; } //Get the unique Leagues recorded in the category function get_meta_values_l( $key = 'League', $type = 'post', $status = 'publish' ) { global $wpdb; if( empty( $key ) ) return; $r = $wpdb->get_col( $wpdb->prepare( " SELECT DISTINCT pm.meta_value FROM {$wpdb->postmeta} pm LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id WHERE pm.meta_key = '%s' AND p.post_status = '%s' AND p.post_type = '%s' ORDER BY pm.meta_value ASC ", $key, $status, $type ) ); return $r; } $meta_value_league = get_meta_values_l( 'League' ); if( !empty( $meta_value_league ) ) { $meta_counts_league = array(); foreach( $meta_value_league as $meta_league ) $meta_counts_league[] = $meta_league; } //$args = array( 'category' => 8 ); //$posts = get_posts($args); //$meta_values = array(); //foreach ($posts as $post) { // $meta = get_post_meta($post->ID, 'Discipline', true); // if the value is repeated, we don't need to save it. // if (!(in_array( $meta, $meta_values))) { // $meta_values[]=$meta; // } //} ?>

BSMG Clients

Sporting Discipline Selected: -



Niamh Briggs
Keith Earls
Peter Stringer
Sarah Lavin
Jack McGrath
Tommy O’Donnell
Donncha O’Callaghan
Bernard Jackman
Jack Conan
Duncan Casey
Shane Jennings
Ben Woods
Mick Kearney
Dmitri Arhip
Brian Cody
Ruairi Cushion
Alan Cotter
Ross Wardle
Jack O’Connell
Cathal Sheridan
Conor Joyce
Jamie Hagan
Ross Jones
Marc Thomas
Vasily Artemyev
Mike Prendergast
Eamonn Sheridan
Jason Holland
Seán Doyle
Luke O’Dea
Brian Hayes
Paddy Butler
Steve Crosbie
Sean Scanlon
Tom Sexton
Matt Williams
James Hart
Sean Henry
Ben Marshall
Ruaidhri Murphy
Darren Hudson
Cian Curley
Andrei Ostrikov
Nicole Coffey
Kevin O’Brien
Michael Bent
Eoghan Grace
Shane Layden