HELP: SELECT only last last few records that were created within last 5 minutes

[Neeper]

Hi,

I've got a transactions table with a tstamp field (datetime type) and
I need help creating a SELECT query to retrieve only last transactions
that occured within the last 5 minutes. The datetime type writes the
tstamp as YYYY-MM-DD HH-MM-SS and I am using mySQL 4.1.

Please help.

[jerry gitomer]

Neeper wrote:

Hi,

I've got a transactions table with a tstamp field (datetime type) and
I need help creating a SELECT query to retrieve only last transactions
that occured within the last 5 minutes. The datetime type writes the
tstamp as YYYY-MM-DD HH-MM-SS and I am using mySQL 4.1.

Please help.

Neeper,

Calculate the start time in the program which calls your MySQL
query and pass it in as a parameter.

For example in PHP you would have a statement something like:

$starttime = time() - 300;

and would then use in the call to your retrieval program/function.

retrieve_functi on($starttime);

Where:
time() if the PHP function that returns the current time
of day.

300 is the number of seconds in 5 minutes.
HTH
Jerry

[Neeper]

Is there anyway of just using a straight mySQL statement without any
PHP manipulation?

On Sun, 24 Apr 2005 12:36:04 GMT, jerry gitomer <jg******@veriz on.net>
wrote:

Neeper wrote:

Hi,

I've got a transactions table with a tstamp field (datetime type) and
I need help creating a SELECT query to retrieve only last transactions
that occured within the last 5 minutes. The datetime type writes the
tstamp as YYYY-MM-DD HH-MM-SS and I am using mySQL 4.1.

Please help.

Neeper,

Calculate the start time in the program which calls your MySQL
query and pass it in as a parameter.

For example in PHP you would have a statement something like:

$starttime = time() - 300;

and would then use in the call to your retrieval program/function.

retrieve_functi on($starttime);

Where:
time() if the PHP function that returns the current time
of day.

300 is the number of seconds in 5 minutes.
HTH
Jerry

[Felix Geerinckx]

On 25/04/2005, Neeper wrote:

Neeper wrote:

I've got a transactions table with a tstamp field (datetime type) and
I need help creating a SELECT query to retrieve only last
transactions that occured within the last 5 minutes. The datetime
type writes the tstamp as YYYY-MM-DD HH-MM-SS and I am using mySQL
4.1.

Is there anyway of just using a straight mySQL statement without any
PHP manipulation?

USE TEST;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo
(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, ts DATETIME);

SELECT id FROM foo WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < ts;
--
felix

[Neeper]

Thank you felix.
On Mon, 25 Apr 2005 10:55:58 GMT, "Felix Geerinckx"
<fe************ *@gmail.com> wrote:

On 25/04/2005, Neeper wrote:

Neeper wrote:

I've got a transactions table with a tstamp field (datetime type) and
I need help creating a SELECT query to retrieve only last
transactions that occured within the last 5 minutes. The datetime
type writes the tstamp as YYYY-MM-DD HH-MM-SS and I am using mySQL
4.1.

Is there anyway of just using a straight mySQL statement without any
PHP manipulation?

USE TEST;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo
(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, ts DATETIME);

SELECT id FROM foo WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < ts;