Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: bb_query: get topics started within a date range?


Sam Bauers
Participant

@sambauers

BB_Query can’t do this at the moment as far as I can tell. It probably should though.

I’ll make a trac ticket to suggest this.

At the moment you could do two BB_Queries and intersect their results. But that’s pretty poor.

Just be sure if you do use a direct query that you prepare it first. e.g.:

$startdate="20070602103049";
$enddate="20080212090232";

$query = $bbdb->prepare("SELECT * FROM %s WHERE topic_start_time BETWEEN %s AND %s ORDER BY topic_start_time DESC", $bbdb->topics, $startdate, $enddate);
$topics = $bbdb->get_results($query);

Skip to toolbar