Use of Timestamp to produce a list.

[BadChough]

I want to summonds to a page a list of people whose MSQL records have been updated since a certain date.

So I enter the date and the names are returned.
I have a timestamp field already on the relevant table, but have never known quite how to make use of it.
I am using Dreamweaver MX2004 and have a little experience with php/MYSQL.

 

[jpadie]

select * from tablename where dateColumn >= date_sub(now(), interval 1 month)

i believe that this query will return records whose timestamp (datecolumn) is less the one month old.