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]