Get the total of a feild

2002-10-01 Thread Chuck Payne 

Hi,

I wanting to know what the sql statement is that will let me get the total
of database. The feild is amount. I have tried a couple of sql statement and
have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.

Chuck Payne
Magi Design



-
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

Re: Get the total of a feild

2002-10-01 Thread nellA hciR 

sounds like you need SUM(field name)

- hcir

 Hi,

 I wanting to know what the sql statement is that will let me get the 
 total
 of database. The feild is amount. I have tried a couple of sql 
 statement and
 have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.


-
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

Re: Get the total of a feild

2002-10-01 Thread nellA hciR 

sounds like you need SUM(field name)

- hcir

 Hi,

 I wanting to know what the sql statement is that will let me get the 
 total
 of database. The feild is amount. I have tried a couple of sql 
 statement and
 have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.


-
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