what would be the best way of doint this?

accurax

I have a function that allows my users to search my database, and i want to limit the mumber of queries a user can do in a given 24 hour period.

I can write a script that increments a field in my database everytime a user conducts a search, and i can stop them searching if this value is at a given limit.

But how do i go about resetting this field to zero every 24 hours?

any suggestions on this are gretaly appreciated guys 🙂

NogDog

I might create a 2-column table with the fields being the user ID and a datetime field. When a user requests a search, you would:

Delete all records from that table where the datetime is > 24 hours ago.
Do a SELECT COUNT() from the table where the user ID matches.
If the count is < maximum allowed, insert a new row for that user ID with the current datetime, then (finally!) perform the user-requested query