Basically the select statement within this:
Code:
DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 10 DAY) > time ) )
will return rows... roughly 4000... But the delete statement will NEVER delete the data from wc3_player_race... I have NO idea why - anyone know how to make this work or another method to do it? I tried temporary tables as well (see comment
here - there is also a DB dump if anyone wants to play with this)
TY!!!!!
Josh
__________________