[insert_php]
global $wpdb;
//Extract the data
$myrows = $wpdb->get_results( “SELECT ID,
dato,
DATE_FORMAT(dato,’%d-%m-%Y’) AS arrangement_dato, dato_tekst, beskrivelse, proeveleder, dommer, er_proeve, tilmeld, resultatlink,
ch_dat, DATE_FORMAT(ch_dat,’%d-%m-%Y’) AS opd_dat, brugerid
FROM arrangementer
WHERE slettet = ‘N’ AND er_proeve = ‘J’ AND DATE(dato) <= DATE(NOW())
ORDER BY dato DESC" );
//Present the data
echo "
” ;echo “Vælg”;echo “ | ” ;echo “Dato”;echo “ | ” ; echo “Beskrivelse”;echo “ | ” ; echo “Prøveleder/Ansvarlig”;echo “ | ” ; echo “Dommer/Info”;echo “ | |
Vis detaljer | ID; echo”>Vis detaljer | ” ;echo $myrows->arrangement_dato;echo “ | ” ; echo $myrows->beskrivelse;echo “ | ” ; echo $myrows->proeveleder;echo “ | ” ; echo $myrows->dommer;echo “ |
[/insert_php]