[RESOLVED] timestamp problem

[bumbar]

Hallo!

I have a table in Mysql and a column date. Column date is type timestamp.
The format timestamp is like '2008-03-24 09:45:52'.

How should I take the recordings by a current date with PHP script?

If today is 2008-03-24, i want the humans who logged from 2008-03-24.
If today is 2008-03-23, i want the humans who logged from 2008-03-23.

Some be help me?:queasy:

[NogDog]

SELECT . . . WHERE DATE(`date`) = '2008-03-24'

[bumbar]

Thankx. The issue is decided.