For example:
Code: Select all
$sql = "SELECT * FROM `table` WHERE `date` > (CURRENT_TIME - X_TIME)"; //Where X_TIME is a few seconds or minutes.
Thank you for taking the time to read this post.
Moderator: General Moderators
Code: Select all
$sql = "SELECT * FROM `table` WHERE `date` > (CURRENT_TIME - X_TIME)"; //Where X_TIME is a few seconds or minutes.
Code: Select all
$sql = "SELECT * FROM `table` WHERE `date` > NOW() - INTERVAL 2 MINUTE";