1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| $jour=date('w');
$h=date('H');
$query = '
SELECT
radio_emissions_onair.onair_id,
radio_emissions_onair.onair_emission_id,
radio_emissions_onair.onair_jourdebut,
radio_emissions_onair.onair_jourfin,
radio_emissions_onair.onair_hdebut as hdebut,
radio_emissions_onair.onair_mdebut as mdebut,
radio_emissions_onair.onair_hfin as hfin,
radio_emissions_onair.onair_mfin as mfin,
radio_emissions_onair.onair_etat,
radio_emissions.id as id,
radio_emissions.titre as titre,
radio_emissions.images as images,
radio_emissions.description as description,
radio_emissions.id_cat as id_cat
FROM radio_emissions_onair
INNER JOIN radio_emissions
ON
radio_emissions_onair.onair_emission_id = radio_emissions.id
WHERE $h>=radio_emissions_onair.onair_hdebut && $h<radio_emissions_onair.onair_hfin
LIMIT 1;'; |
Partager