Selecting record edited within last 2 minuites

[USBZ0r]

Hi there guys!

Im struggling to find a way to select all rows from a MySQL table that were edited within the last 2 minuites. When the user edits their profile, it time stamps it. So all i need to do is fetch all rows that were time stamped within the last 2 minuites of the current time.

anyone have any ideas how it would be done in PHP/SQL?

Thanks

[Markus]

@USBZ0r
Are you using mysql's timestamp? Or what kind of time stamp are you using?

[USBZ0r]

TimeStamp yes

Thanks for reply.

[Markus]

@USBZ0r
Ok, so the way that makes sense to me is to convert your timestamp into seconds using UNIX_TIMESTAMP( column ) and then use TIMEDIFF against current UNIX_TIMESTAMP() (note: no argument given).

Something like below:

SELECT 
  *
FROM
  `tbl_name`
WHERE
  TIMEDIFF
  (
    UNIX_TIMESTAMP(),
    UNIX_TIMESTAMP( `tmestmp_clmn` )
  ) < 121

Does that make sense?

[USBZ0r]

thanks!

kinda does yeah, but is TimeDIF PHP or MySQL valid? and i take it tmestmp_clmn would be where the time stamp in my database gets put?

[Markus]

@USBZ0r
UNIX_TIMESTAMP() and DATEDIFF() are MySQL functions. They can be used in your SQL queries.

$query = "
SELECT
  ...
  ...
  DATEDIFF( ... )";
 

Yep, you will have to rename the columns to reflect your table set up.

[USBZ0r]

Thanks mark, il give that a try!

[Markus]

@USBZ0r
Let us know if you have any problems or questions.

- mark.