Comments on toplist question

•jsflinks Experienced Usergroup: Customer Joined: Jul 28, 2005 Total Topics: 30 Total Comments: 55	•jsflinks #1 - Quote - Permalink Posted Nov 12, 2005 - 4:29 PM: I'm trying to create a toplist that will show the links with the most number of hits for links that have been posted in the last 90 days. Is there a variable that counts how old a link is for use in toplists?
•Paul developer Usergroup: Administrator Joined: Dec 20, 2001 Location: Diamond Springs, California Total Topics: 61 Total Comments: 7868	•Paul #2 - Quote - Permalink Posted Nov 13, 2005 - 11:48 AM: Use this condition: time > UNIX_TIMESTAMP() - (86400 * 90) (that tells it to include everything submitted later than now minus the number of seconds there are in 90 days)

This thread is closed, so you cannot post a reply.