I have the following line:
mysql_query("DELETE FROM sessionstable WHERE (TO_DAYS(now()) - TO_DAYS(lasthit)) > 1 ")or DIE(mysql_error());
sometimes i surf around on my website where many people are logged in at the same time.
and my session gets deleted. even though lasthit is not smaller than 1 day.
lasthit is a datetime field.
any idea?
this is the only DELETE query in the whole script on the sessionstable.