Thanks for the reply, I just got it and it would have helped but I ended up doing this. I am testing the solution now and I think it works. I had to remove the time condition from the sql statement and test the time in php, because, if the date is any other day than today then the time doesn't really matter. And besides my logic was a little off. I only had to get results if they were past the current date and time. So the statement looks like this:
I also just posted a problem about having to add minutes to the time of the returned record here. For instance 30 mins needs to be added to the record. Thinnk you could give me a hand with this. I searched the board to look for help using the ADDTIME function but there was only one post that didn't help much. The details are in the post....
SELECT member.email, member.l_name, member.f_name, tasks.task_id, tasks.assigned_to, tasks.alarm_me, tasks.alarm_date, tasks.additional_notes, CONVERT(tasks.alarm_time,TIME), tasks.title FROM tasks,member WHERE member.member_id = tasks.assigned_to AND tasks.alarm_status='Pending' AND tasks.alarm_me='Y' AND tasks.alarm_date <=CURDATE()