Hi Both, quick update to my previous post.
I have this as a recordset query:
SELECT *
FROM tasks
WHERE dueDateTime <= DATE_FORMAT(NOW(), '%Y-%m-%d %h:%m')
AND alertShown <> 1
For some reason, it does not work.
This is the table structure for tasks within MySQL:
`taskId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` text,
`text` text,
`currentStatus` text,
`taskType` text,
`createdUsername` text,
`assignedUsername` text,
`dueDateTime` datetime DEFAULT NULL,
`createdDateTime` text,
`priority` text,
`alertShown` int(11) NOT NULL,
PRIMARY KEY (`taskId`)
I'm not sure why I dont get any records if I insert a new record with the dueDateTime as 2009-11-01 18:40:00 and set the alertShown value to 0 and wait for the computers clock to reach 18:40 or even go to 18:41 etc (remember that I have a jQuery div on the page that reloads the content of the page with the recordset on it every 10 seconds, the user does not have to manualy refresh the page, even if they do no record is displayed).