At 17.11.2001 14:45, Srinivasan Ranganathan wrote:
>I need to store the date and time of sign-up and date
>and time of last successful login in a mysql database
>and calculate how long the user has been using a site.
>how do i do this?
Store date either in seconds since 19700101 or use your
rdbms' datefield (most of them've got one).
(I always prefer seconds as it's IMHO the easier to do calculations
Andreas D Landmark / noXtension
Real Time, adj.:
Here and now, as opposed to fake time, which only occurs there
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]