PDA

View Full Version : Only Grab Certain Dates ..


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?