View Full Version : Month events

04-24-2006, 07:41 PM
I have registers in a mysql DB and I want to show them for months. I think I have a var like this:

$id = "month(now())";
$sql = "select * from agenda_geral where agenda='desporto' and month = ".$id." and area_ID = 1 order by day" ;

But what I have to do for show the next or the previous month events in the same page without create a new??