In need of a bit of help.. PHP/MySQL related

[just.b.jealous]

More or less- using it as a safe guard from users-overclicking. Our site doesn't have problems with bots or anything. Also helps filter unneeded mail.

Could you (well do you mind) helping me with what code I would need to accomplish this? I could read from the code what tables would need to be created- I just need help with actually implementing the checks on the page and what not... Total newb- yeah I know. Oh and I know the ins and out of my hosting/cpanel so you wouldn't have to hold my hand the whole way

--------------- Added [DATE]1313947385[/DATE] at [TIME]1313947385[/TIME] ---------------

I've just been told about trying:

select count(*) as last_hour_clicks
from table 
where ip_address = inet_aton('x.y.z.k') and click_time >= now() - interval 1 hour

But yeah- I'm not to sure what to actually do with it,..


My coding where it needs to be implementing is simple- just not sure how to wrap myself around it- and I'm even unsure of the guys tables, lol now that I'm looking at that code again- how's it even enter the persons last details, wthm. ^.^

<div class="newest-item">
	<div class="newest-img">
		<img src="uploads/3.png" alt="Giveaway" width="120" height="120"/>
	</div>
	<div class="newest-desc"><p>Plastic Chair</p></div>
		<a class="add-cart" href="./forms/1.html" title="Enter for you chance to win!"><span>Enter Email</span></a>
	</div> 
</div>