ok here is my situation:
i have this code
$query = "SELECT e., t., p.* FROM event AS e, thread AS t, post AS p WHERE t.forumid = 16 AND t.threadid = p.threadid AND p.parentid = 0 AND t.title LIKE '$yo' AND t.forumid = '16' AND e.eventid = t.lv_vb_eventforums_eventid ORDER BY e.dateline_from DESC LIMIT $affichage";
as you can see, my table "event" contains a row called "DATELINE_FROM". It contains a date for each entry that was added, but it is unix-encrypted and looks like 3472139847 instead of 01/01/2008.
What I want to do, is limit my query to the entries where DATELINE_FROM is inferior of today's date.... this way it will display only the upcomming events, and not the old ones
how can I do this?
