David Schure
asked on
Query on Todays Date and Status
Trying to run a query on todays date.
SELECT
COUNT(*)
FROM
tbl_session
WHERE session_date = today()
AND session_status=Booked;
This is what I am getting back
What database are you using MySQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or use the php equivalent to inject the value into the query....
You can use $date
$date = date('Y-m-d')
$date = date('Y-m-d')
ASKER
Thank you CURDATE() worked. Now it's complaining about the Booked part.
ASKER
Got it thank you!
SELECT
COUNT(*)
FROM
tbl_session
WHERE
session_date=CURDATE()
AND
session_status="Booked";