noonespecial
03-19-2006, 08:27 PM
Current code:
$db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title
FROM event
WHERE calendarid = 3 AND dateline_from >= UNIX_TIMESTAMP()
ORDER BY dateline_from LIMIT 250");
What I want to do is be able set it to only pull dates for one month. For example, from March 1st to March 31st. Only ..
How exactly would I do this?
$db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title
FROM event
WHERE calendarid = 3 AND dateline_from >= UNIX_TIMESTAMP()
ORDER BY dateline_from LIMIT 250");
What I want to do is be able set it to only pull dates for one month. For example, from March 1st to March 31st. Only ..
How exactly would I do this?