= cast((now() - interval 0 day) as date)"; $query = mysqli_query($link, $str); while ($res = mysqli_fetch_object($query)) { $dayplans[] = $res; } ?>