Hi,
I'm building a small shop system and got a few problems, here they are :
Each user that go on the site get an userid and a new entry in a table is created, that looks so :
srand ((double)microtime()*1000000);
$usrID = rand();
$time=date(G);
mysql_query("INSERT INTO users (usrID,Zeit) VALUES ('".$usrID."','".$time."')")
or die("Error !<br><b>".mysql_error()."</b>");
Works realy fine, but there is a problem : if a userid is older than one hour (and isn't permanent, that means no one bougt something under it) it have to get deleted. My query for this looks so :
mysql_query("DELETE * FROM users WHERE ZEIT != '".$time.""');
Did i use the comparsion operator in a false way or why doesn't it work ?
