mysql_query time within X minutes...

[newbtophp]

I want to do a flood check to check if the topic_author has posted a topic previously within the last 5 minutes.

 

I have the following columns, topic_date (which is a timestamp which i insert using time()) and topic_author (the topic author).

 

Heres what im doing currently:

 

<?php
$username = "newbtophp";
$flood_check = mysql_num_rows(mysql_query("SELECT * FROM site_topics WHERE topic_author = '{$username}' AND topic_date {IS WITHIN LAST 5 MINUTES FROM CURRENT TIME}"));

if ($flood_check > 0){
//you need to wait X more minutes to post again...

}
?>

 

Anyone can help me with the query neccesary?  :-\

[newbtophp]

Figured it out by just doing it with php instead of it all within a query.