At 17.11.2001 14:45, Srinivasan Ranganathan wrote:
>Hi
>
>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
with)


-- 
Andreas D Landmark / noXtension
Real Time, adj.:
         Here and now, as opposed to fake time, which only occurs there
and then.


-- 
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]

Reply via email to