Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Order by timestamp WITH simple math calculation


neophyte - 1:00 am on Jul 15, 2012 (gmt 0)


LifeinAsia -

Thanks very much... that should have been obvious to me.

Now, however, the error I'm getting is Unknown column 'UNIX_TIMESTAMP' in 'where clause'.

I would think that the WHERE clause is keying off fld_approved within the parens, but apparently not.

I've tried WHERE((fld_approved + 259200) < UNIX_TIMESTAMP) and other variations which would force the identification of fld_approved, but without any luck.

Any ideas?


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4475614.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com