Codice PHP:
$array = array();
for ($i=$dal; $i<=$al; $i+=86400) {
$giorno = "$i";
$table_tutor = "nome_tabella_tutor";
$table_impegnati = "nome_tabella_tutor_impegnati";
$query = "SELECT DISTINCT(tg.id_tutor) AS tid, tg.id_name AS tname FROM $table_tutor AS tg WHERE tg.id_tutor NOT IN(SELECT id_tutor FROM $table_impegnati WHERE dal<='$giorno' AND al>='$giorno')";
$query= mysql_query($query);
$tot=mysql_num_rows($query);
while ($a_row = mysql_fetch_array($query)) {
$tid = $a_row['tid'];
$tname = $a_row['tname'];
if(!in_array($tname, $array)) $array[$tid] = $tname;
}
}
foreach($array as $key=>$value) {
echo "id:".$key." - nome:".$value."
";
}
Occhio alla punteggiatura, ho scritto in fretta.. Ciao