i,
I have to write simple mysql script. I need folowing things:
Number of people logged in previous 0 to 24 hours
Number of people logged in previous 24.5 to 48 hours
Number of people logged in previous 48.5 to 72 hours
Number of people logged in previous 72.5 hours to 7 days
Number of people logged in previous 7.5 to 14 days
Number of people logged in previous 14.5 days onwards
My tables is as follows:
mysql> select * from User limit 1;
+--------------+-----------+---------------------+--------------+
| partner_name | user_name | last_login | mailbox_size |
+--------------+-----------+---------------------+--------------+
| foo.net | edward | 2001-06-02 09:37:41 | 229099 |
+--------------+-----------+---------------------+--------------+
1 row in set (0.62 sec)
I also want to save the output to comma delimited file.
Cheers
kapil
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php