Re: Date/Time Logic

It sounds like you're asking for triggers, which are available yet. But you could setup a cron job to run every night to update the database. It would be no different than doing a nightly dump for backup. You could even have it email you the accounts that were closed and those that will be closing in the next week or two. If that won't work for you, then you can just have the user login kick of the disabling code. It would still restrict access, but wouldn't give you the timely notification you're asking for. On Wednesday, February 19, 2003, at 12:46 PM, Pushpinder Singh Garcha wrote:

Hello Everyone, My php/mysql application needs to keep track of the first time that a User logs on to the site. Afterwards the User should be allowed either 3 days / 3 months/1 year of access to the site. Once the stipulated time period is over the system should invalidate the login of the user. The Admin/ User should get email notification about this. The notification part is easy the hard part to figure out is how to be able to keep and tab on the Time Period stipulated for a user. Thanks in advance Pushpinder Singh Garcha _________________________________ Web Architect --

Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577