Re: Month events

[Dave Walker]

Hi, Try this:

<?
$one_week=604800;// seconds
$id = "month(now())";
$one_week_old = $id-$one_week;

$sql = "select * from agenda_geral
where agenda='desporto'
and month >= ".$one_week_old."
and month <= ".$id."
and area_ID = 1
order by day" ;
?>

The query will retrieve records made in the last 7 days.

Hope it helps ;-)

Dave

UK MySQL Web Hosting: http://www.seiretto.com