Kommende arrangementer
[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,
ch_dat, DATE_FORMAT(ch_dat,’%d-%m-%Y’) AS opd_dat,
brugerid
FROM arrangementer
WHERE slettet = ‘N’
AND DATE(arrangementer.dato) >= DATE(NOW())
ORDER BY dato” );
//Present the data
echo “
” ;echo “Dato”;echo “ | ” ; echo “Beskrivelse”;echo “ | ” ; echo “Prøveleder/Ansvarlig”;echo “ | ” ; echo “Dommer/Info”;echo “ |
” ;echo $dato_tekst;echo “ | ” ; echo $myrows->beskrivelse;echo “ | ” ; echo $myrows->proeveleder;echo “ | ” ; echo $myrows->dommer;echo “ |
[/insert_php]
Hele årets (2018) arrangementer
[insert_php]
//Extract the data
$myrows = $wpdb->get_results( “SELECT ID,
dato,
DATE_FORMAT(dato,’%d-%m-%Y’) AS arrangement_dato,
dato_tekst,
beskrivelse,
proeveleder,
dommer,
ch_dat, DATE_FORMAT(ch_dat,’%d-%m-%Y’) AS opd_dat,
brugerid
FROM arrangementer
WHERE slettet = ‘N’
AND DATE(arrangementer.dato) >= ‘2018-01-01’ AND DATE(arrangementer.dato) <= '2018-12-31'
ORDER BY dato" );
//Present the data
echo "
” ;echo “Dato”;echo “ | ” ; echo “Beskrivelse”;echo “ | ” ; echo “Prøveleder/Ansvarlig”;echo “ | ” ; echo “Dommer/Info”;echo “ |
” ;echo $dato_tekst;echo “ | ” ; echo $myrows->beskrivelse;echo “ | ” ; echo $myrows->proeveleder;echo “ | ” ; echo $myrows->dommer;echo “ |
[/insert_php]