Enjoy your Wellness...Join the Revolution
I nostri corsi
$sqldisc = "SELECT * FROM discipline where del=0 order by disciplina";
$result_disc = mysqli_query($conn_m, $sqldisc);
while($disc_obj = mysqli_fetch_array($result_disc, MYSQLI_ASSOC)){
?>
}
mysqli_free_result($result_disc);
?>
$mydisc = $disc_obj['disciplina'];
if($mydisc == "BALLI CARAIBICI"){ $mydisc = "CARAIBICI"; }
$sqlorari = "SELECT concat_ws(',',hour(orario),if(minute(orario)=0,'00',minute(orario))) as orario,dayweek FROM corsi where corso like '%$mydisc%' order by dayweek, 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['dayweek'];
$orario = $orari_obj['orario'];
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($rsltorari);
?>