Using timestamp?

[vik1ng]

Hi.. I would like to have a select statement from my table
that makes sure the info I am after is caught for at least 5 minutes after the info is added.

WHY: People on my site can send a message that will put their image on my main page. I have limited the query to show only 5 images. I now want the images to be visable for at least 5 minutes. So my problem is how to make a queue so even if more than 5 rows are added to the table the images still will be visable for at least 5 minutes.

I have a time column in the table with type timestamp(12). I
guess I have to do something with that.
Any Idea anyone on what I could do?

 

[TonyGroves]

How about something like:
[tt]
SELECT mugshot
FROM userdata
ORDER BY timeadded DESC
LIMIT 5
UNION
SELECT mugshot
FROM userdata
WHERE timeadded > NOW() - INTERVAL 5 MINUTE
[/tt]