How do I fix my SQL query to select IDs between specific date times in PHP?

SELECT id FROM schedule_list WHERE start_datetime BETWEEN ‘$start_datetime’ AND ‘$end_datetime

Why this command didn’t work to identify the between time in my start_datetime and end_datetime

correct sql query for my php. thanks