[PHP] Re: Date/Time Logic

2003-02-19 Thread Philip Hallstrom
Store the timestamp of their first login to a database. Also store the number of days (3, 90, 365) that there account is valid. Setup a script to nightly go through the database and for any records where: first_login_timstamp + number_of_days < right_now is true invalidate their login and send

[PHP] Re: Date & time

2002-01-29 Thread Gaylen Fraley
To correct the time, try this: "; $time = $time + (7*60*60); echo "adjusted time = ".date("Y/m/d H:i:s",$time).""; ?> -- Gaylen [EMAIL PROTECTED] Home http://www.gaylenandmargie.com/ PHP KISGB v3.22 Guest Book http://www.gaylenandmargie.com/phpwebsite/ "Torkil Johnsen" <[EMAIL PROTECTED]> wrote

RE: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Shrout, Ryan
lto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 3:43 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: Date/Time Query Help On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: > >WHERE 2001

Re: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Bopolissimus Platypus
On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: > >WHERE 2001-07-24 15:03:24 > SUBTRACTION( 2001-07-24 15:30:21, 00:01:00) = >WHERE 2001-07-24 15:03:24 > 2001-07-24 14:30:21 i just tested on my box (d

RE: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Shrout, Ryan
Heh. :) So, does anyone know what I am doing wrong? Ryan Shrout -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 3:34 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: Date/Time Query Help On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL

Re: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Bopolissimus Platypus
On Tue, 24 Jul 2001 15:23:10 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >Think of it this way: > >WHERE session.Date > DATE_SUB(NOW(), INTERVAL 1 HOUR) is equal to: > >WHERE 2001-07-24 15:03:24 > SUBTRACTION( 2001-07-24 15:30:21, 00:01:00) = >WHERE 2001-07-24 15:03:24 > 2001-07-24 14:30:21 >

RE: [PHP] Re: Date/Time Query Help

2001-07-24 Thread Shrout, Ryan
sage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 2:58 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: Date/Time Query Help On Tue, 24 Jul 2001 15:09:14 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >I need a MySQL query that will select all the entries in i

[PHP] Re: Date/Time Query Help

2001-07-24 Thread Bopolissimus Platypus
On Tue, 24 Jul 2001 15:09:14 -0400, [EMAIL PROTECTED] (Ryan Shrout) wrote: >I need a MySQL query that will select all the entries in it made within the >last hour. > >I tried this, but it is not working correctly, what am I doing wrong? > >SELECT *