getGiorni();
foreach ($days as &$d){
$d++;
}
$query="select count(id), timestamp from
(SELECT CURDATE() + INTERVAL (a + b) DAY AS timestamp
FROM
(SELECT 0 a UNION SELECT 1 a UNION SELECT 2 UNION SELECT 3
UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7
UNION SELECT 8 UNION SELECT 9 ) d,
(SELECT 0 b UNION SELECT 10 UNION SELECT 20
UNION SELECT 30 UNION SELECT 40 ) m
ORDER BY a + b
) z
left join ( select id, date(data) as timestamp from cittadinanza ) f
using (timestamp)
where dayofweek(timestamp) in (".implode(",",$days).")
group by timestamp
having count(id)<".$sp->getMaxAppuntamenti()."
order by timestamp asc
limit 1";
$rx=mysql_query($query,$link) or die(mysql_error().$query);
while ($row=mysql_fetch_array($rx)){
$mindate=$row[1];
}
$tmp=explode('-',$mindate);
$mindate=$tmp[2]."/".$tmp[1]."/".$tmp[0];
mysql_close($link);
?>
PRENOTAZIONE
Partner del Progetto
