Ok so I am making a “voting” page… And I need the table to clear the an ip 24 hours after the ip is added onto the table.
Here is my Table
[code]CREATE TABLE tempvotes (
id int(5) NOT NULL,
time int(9) NOT NULL,
ipaddress varchar(15) NOT NULL,
voted int(1) NOT NULL default ‘0’
) ENGINE=MyISAM;
CREATE TABLE votes (
id int(11) NOT NULL auto_increment,
time int(9) NOT NULL,
ipaddress varchar(15) NOT NULL,
authcode varchar(6) NOT NULL,
used int(1) NOT NULL default ‘0’,
username varchar(14) NOT NULL,
guid varchar(45) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM[/code]