2.00609119313E+13 Options

[CodeKing]

In the following code doesn't work. It's suppose to delete users who haven't confirmed their account within 24 hours.

<?
$dbh=mysql_connect ("localhost", "mostmojo_mojo", "*********") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("mostmojo_members");
print($signtime = date("YmdHis")-240000);
$query = "DELETE FROM `users` WHERE `confirm`='0' AND `signtime`<'".$signtime."'";
if (!mysql_query($query))
{
print(mysql_error());
}
mysql_close($dbh);
?>

$signtime outputs as 2.00609119313E+13. Is that the reason it doesn't work? If you need any info about the database, just ask.

[Brian Chandler]

In the following code doesn't work. It's suppose to delete users who haven't confirmed their account within 24 hours.

<?
$dbh=mysql_connect ("localhost", "mostmojo_mojo", "*********") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("mostmojo_members");
print($signtime = date("YmdHis")-240000);
$query = "DELETE FROM `users` WHERE `confirm`='0' AND `signtime`<'".$signtime."'";
if (!mysql_query($query))
{
print(mysql_error());
}
mysql_close($dbh);
?>

$signtime outputs as 2.00609119313E+13. Is that the reason it doesn't work? If you need any info about the database, just ask.

In what format do you write the signup time to the DB? Using date("YmdHis")? This seems extravagant - and gives you *enormous* pseudo-numbers to subtract, which may lead to problems with floating point overflow and goodness knows what. Why not just throw away the minutes and seconds, and record to the nearest hour? Notice that the value above is 2006-09-11 @ 9313, except that 9313 is not an obvious time.

Why are there _three_ different sorts of quotes in the MySQL query?