I NOSTRI CORSI
$query = "SELECT distinct(dayweek) as giorno FROM corsi order by dayweek";
$result = mysqli_query($conn_m, $query);
while($sql_obj = mysqli_fetch_array($result, MYSQLI_ASSOC)){
$numday = $sql_obj['giorno'];
if($numday==2){
$dweek = "lunedi";
}elseif ($numday==3) {
$dweek = "martedi";
}elseif ($numday==4) {
$dweek = "mercoledi";
}elseif ($numday==5) {
$dweek = "giovedi";
}elseif ($numday==6) {
$dweek = "venerdi";
}elseif ($numday==7) {
$dweek = "sabato";
}elseif ($numday==1) {
$dweek = "domenica";
}
?>
}
mysqli_free_result($result);
?>
$sqlorari = "SELECT concat_ws(',',hour(orario),if(minute(orario)=0,'00',minute(orario))) as orario,corso FROM corsi where dayweek='$numday' order by orario";
$rsltorari = mysqli_query($conn_m, $sqlorari);
$totorari = mysqli_num_rows($rsltorari);
if($totorari > 0){
?>
while($orari_obj = mysqli_fetch_array($rsltorari, MYSQLI_ASSOC)){
$numday = $orari_obj['orario'];
$corso = $orari_obj['corso'];
?>
}
?>
--
}
mysqli_free_result($rsltorari);
?>