Eric,
Thank you for the information! It works fine! I did go to the page
below, but it was for Mathematical EQUATIONS, like syne,radius,
circum, etc... I looked under all of those pages and never really saw and
reference to simply pulling totals out.
I really appreciate it! It works GREAT!
==============================================================================
Phillip Ferraro WorldNet Access, Inc
[EMAIL PROTECTED] Onslow County's PREMIER InterNet Service
Voice (910) 346-0835 824 Gumbranch Square, Suite Q
FAX (910) 455-1933 Jacksonville, Nc 28540-6269
==============================================================================
On Fri, 26 Jan 2001, Eric Fitzgerald wrote:
> http://www.mysql.com/doc/M/a/Mathematical_functions.html
>
> Please please please read manual before asking questions.
>
> SELECT SUM(minutes) AS ttltime, user FROM table WHERE user = 'someuser'
> GROUP BY user
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, January 26, 2001 3:00 PM
> Subject: Getting totals from database
>
>
> >
> > I know this is probably a simple thing, but what I would like to
> > be able to do, is to query a specific account name for minutes each day
> > and then have those minutes ADDED up to show the current total time
> > online.
> >
> > My database has all of the info in the table, all I want to do is be
> > able to query for a specific user and show total time for the month to
> > date.
> >
> > Any help appreciated! Please reply via separate email..
> >
> >
> ============================================================================
> ==
> > Phillip Ferraro WorldNet Access, Inc
> > [EMAIL PROTECTED] Onslow County's PREMIER InterNet Service
> > Voice (910) 346-0835 824 Gumbranch Square, Suite Q
> > FAX (910) 455-1933 Jacksonville, Nc 28540-6269
> >
> ============================================================================
> ==
> >
> >
> > ---------------------------------------------------------------------
> > 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
> >
> >
> >
>
>
---------------------------------------------------------------------
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
