Now() + 1 Day = [Yesterday, Tomorrow] (but tomorrow doesn't exist yet, so...)
Have a look to:
https://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html[
^]
Have you tried the
CURDATE
(Current date = today)´
Or you get the
NOW
and then use the
DATE
to extract the current day for your query.
Working query copied from OP's Comment below to be easier to spot
$query = "SELECT name, date, time, queue FROM sms_traffic_db.table_data WHERE date = CURDATE()";