2.00609119313E+13 |
2.00609119313E+13 |
CodeKing |
Sep 12 2006, 05:08 PM
Post
#1
|
Advanced Member Group: Members Posts: 175 Joined: 12-September 06 Member No.: 118 |
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. |
Lo-Fi Version | Time is now: 18th April 2024 - 01:21 AM |