Spam problem

[Schwalbach]

Hey guys,

I am getting stuck on this..

For some background: I am doing a chat, I have a user name being submitted to a table called user, and a variable I am using is $lastime, which is the lastime the chat was updated. Just in case it is important..

Basically what I want to do is:

Use a SELECT to see if someone has 5 entries into my db within 5 or so seconds..

I am using time() when inserting into my db.

So I am looking for one username(The table user) to be repeated 5 times in 5 or 7 seconds in my database.

Thanks 🙂
Chase

[nemonoman]

SELECT FROM user
WHERE time BETWEEN NOW()
AND NOW()-5 INTERVAL SECOND
GROUP BY username
HAVING count()>4