How Do I Query Calendar for a range of Dates?

[websissy]

Hello.

I'm trying to figure out how to use mysql to query the vbulletin calendar for all events within a range of dates (i.e. select all events from October 1 to November 30). The way vbulletin has its dates stored in the calendar, I've been unable to figure out how to do that. Can someone here please tell me how?

I know it ought to be something like:


Select * from vb_event where dateline_from > "2006-09-30" and dateline_from < "2006-12-01";


except of course, THAT query won't really work!

Thanks!

[nico_swd]

$from = "2006-09-30";
$to = "2006-12-01";

"SELECT * FROM ". TABLE_PREFIX ."event WHERE dateline BETWEEN ". strtotime($from) ." AND ". strtotime($to)


Untested but should work.

Note that the date needs to be in following format: yyyy-mm-dd

Or one of these http://www.gnu.org/software/tar/manual/html_node/tar_109.html