PDA

View Full Version : Using TIMENOW in where Condition Help


paul41598
09-22-2009, 03:26 PM
I'm trying to use an equation in my where clause and I have no idea what to do because of the favorites.alertoptions. Normally you would use a variable like $time instead...however in a column inside a table I have integers defined like 1 or 2. So is it possible to use something like this below rather than a variable? If so how? This isn't working for me. Thanks!

AND thread.expiry <= " . (TIMENOW + (favorites.alertoptions * 60 * 60)) . "