I'm sure you could add up the results as you fetch them and only display the
total.  But even easier why not ask the  DB to return the sum?

SELECT sum(my_col)
  FROM my_table
   WHERE <whatever>

This will only return one row with the total (note you can only select
columns that are using an aggregate for this to work) See also "GROUP BY"

Good luck,
Frank

> 
> From: CÚsar L. Aracena <[EMAIL PROTECTED]>
> Date: Tue, 21 May 2002 01:49:28 -0300
> To: "PHP DB List" <[EMAIL PROTECTED]>
> Subject: Adding totals
> 
> Hi all,
> 
> Is there a way for me in PHP4 to add all the contens (floating numbers) of a
> cartain column whithin a row and show up the result? I have several time
> inputs and need to show the total.
> 
> Thanx.
> 
> Cesar Aracena
> [EMAIL PROTECTED]
> Neuquen, Argentina


-- 
Frank Flynn
Poet, Artist & Mystic



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to