get_header(); do_action('hestia_header'); $listes=$wpdb->get_results("SELECT * FROM listes WHERE visible=1 ORDER BY `defaut` DESC"); function prologue($liste) { global $wpdb; $night=$liste->prefixe . '_prologue'; $person=$liste->prefixe . '_person'; $participant=$liste->prefixe . '_participant'; $participants=$wpdb->get_results("SELECT N.ID,per.last_name,per.first_name FROM $night AS N INNER JOIN $participant AS par INNER JOIN $person AS per WHERE N.person_id = per.id AND N.participant_id = par.id ORDER BY N.ID"); echo "
N° Dossard | Nom | Prénom | "; foreach ($participants as $people) { echo "
---|---|---|
$people->ID | $people->last_name | $people->first_name | "; } echo "