A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index order by date_time asc' at line 1

select coursedate.*, course.title as course_title from coursedate, course where course.id = coursedate.course_id and course.deleted = 0 and coursedate.deleted = 0 and coursedate.date_time > date_add(curdate(), INTERVAL 1 DAY )and coursedate.course_id = index order by date_time asc