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,

> From: CÚsar L. Aracena <[EMAIL PROTECTED]>
> Date: Tue, 21 May 2002 01:49:28 -0300
> 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
> 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