IP Ban/Limit

[shortround4271]

Ok a friend of mine asked me to make him a script that allows an IP to view a page only once per day, using MySql and Php, I know where to start and all, but I'm not fimiliar with MySql, can someone give me a start please? Was hoping to retrieve a column of IP's and convert it into an array and then check it with a loop. And set a cron job for MySql for 24 hours to delete the row with the IP.

[bogu]

U dont need mysql for this, u can use htaccess for this ...

But since u want to use mysql, u need to do something like this:
- when a visitor come on that page u make an insertion in your IP ban table and the date when the visitor enter
- your ip field could be uniq so if the insertion is not make then the visitor is still in the ban list
- set up a cron that delete all the records from that table that are older then 24 hours
This could do the trick ...