IP Log Timeout

[Mistah_Roth]

I have an IP logger that puts IPs for each person that votes for a song on my site into a MySQL table. What I need it to do is make it so after 24 hours, the entry either deletes itself or changes a value (ex. an extra column that is set to 1 if the IP has already voted today, and is changed to 0 after 24 hours).

How exactly do I set a timer to allow this? If its not possible or just too complicated then is there a script that would do this to all of the entries at a certain time?

[LordShryku]

Well, simple way would be to have a timestamp column also, then run a cron job tro look them up and update them

[HalfaBee]

I did something similar and did a
DELETE from table where votetime < DATE_SUB( now() , INTERVAL 24 HOUR );
every time the script was run.
No cron needed.

HalfaBee