Hi! I corrently working with a project to build a web based calendar with alarm (reminder for each event).
table 'calendarEvents' start datetime NOT NULL default '0000-00-00 00:00:00' remindTime tinytext NOT NULL The column 'remindTime' specify the time before an event the alarm will go off. For example one event will have remindTime = 10 MINUTE and another moight have remindTime='1 HOUR' I was hoping to get this work by something like this, but it doesn't. select DATE_SUB(start,INTERVAL remindTime) FROM calendarEvents WHERE 1 or select start - INTERVAL remindTime FROM user_calendar WHERE remindTime!='' Any suggestions how todo it? Is it possible to use DATE_SUB in this case? Best regards /Peter sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
