Trying To Grasp Time/Date Within TimeFrame

[paul41598]

Lynne,

Well thats the confusion too is querying the database. Remember my other thread today where in forumdisplay_query hook I had:

PHP Code:

$hook_query_fields .= ", thread_expiry"; 


Well....the problem with extending this query is I don't want to SELECT (UNIX_TIMESTAMP(NOW()) - thread.thread_expiry) , because wont that give me all threads that are expiring in 3 days? I essentially just want to grab all threads and their corresponding expiration date.

THen outside of the query I wanted to write an IF conditional to say "if those threads that have expiry dates and have less than 3 days left before they expire", then turn them red.

is that confusing? Do you need more info? argh