[PHP-DB] Re: Adding totals

[César L . Aracena]

It works...

Thanks a lot.
  ----- Original Message ----- 
  From: Adam Royle 
  To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] 
  Sent: Tuesday, May 21, 2002 2:11 AM
  Subject: Re: Adding totals


  This should be it (if I am understanding you correctly).

  Adam

  $strSQL = "SELECT SUM(columnName) as sum FROM tblName";
  $result = mysql_query($strSQL);

  while ($row = mysql_fetch_array($result)){
      $total = $row["sum"];
  }

  --------------------------------
  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