Counting how many records added in the past 10 minutes

[jacrewq]

There is a field in my table that contains now() timestamp. I'd like to count how many records were added in the last 5 minutes


I came up with this:

$query = "SELECT count(*) FROM msglog WHERE time > FIVE MINUTES AGO";

But how can I get FIVE MINUTES AGO time in MySQL?

Please help!
Alex

[sgoku01]

You could insert a time with time().
That is a UNIX-timestamp.
When you want to select the records that are added in the last 5 minutes you do this:

$time = time()-300;
$query = "SELECT * FROM msglog WHERE time > $time";

300 seconds = 5 minutes 😉

I hope this it what you mean?

[jacrewq]

Thanks but time() returns something like this: 1043707930 but the times in my table are stored in timestamp format: 20030127175521