datefunction and mysql query

[phpprogrammer]

Dear All,

I have a small query

the structure(fileds) of the table is tbl_visitors are as follows

remoteid varchar(15)
accessdate date
accesstime int(15)

i am inserting the ipaddress,accessingdate,accssing time of the clients into the database when they are accessing the site indexpage

my problem is how can i find the count(remoteid) from the previous months ie 1monthbefore,2monthsbefore,3monthsbefore --- 12monthsbefore

plz send me the solution

regards
bvsureshbabu

[trexx]

An example. Calculate $timestamp1 for the 1st april 03, 00:00 then calculate $timestamp2 for 30th april 03, 23:59. now you select the count with:

SELECT COUNT(*) FROM your_table WHERE accesstime > $timestamp1 AND accesstime < $timestamp2;