phpmysqlvote

select time 5 minutes before now

I'm currently writing a script for voting, and I need to know if the user voted in the last 5 minutes. If yes, next vote is forbidden.

How can I make a request for this?

This was my try:

WHERE time AFTER INTERVAL(CURRENT_TIMESTAMP - 5 MINUTES)
Solution 
  • WHERE time > NOW() - INTERVAL 5 MINUTE

    Try that.