[Programme]

My goal is to get the total value from all the records in my DB. A records has the field 'value' and the field 'qty' (quantity).
So far i have this working script:

PHP Code:

$select = "SELECT * FROM table";

$data = mysql_db_query('database', $select) or die("DIE");



while($row = mysql_fetch_array($data))

   {

      $uid = $row['uid'];



      $totals = mysql_query("SELECT (SUM(value) * qty) AS totalSum FROM table WHERE uid = '". $uid ."'") or die("DIE");



      print("$total<br />");

   } 

This gives me the total result for each row on a line. If i had a Two record with the value and quantity like this: 2.00 | 3 & 1.50 | 2

The result i would get is: 6.00 and 3.00. The result i want is 9.00. I want to get the total result of all my records. How can this be done? Thanks

[NeverMind]

remove the WHERE clause and you will get the sum of all records.

[Programme]

Sorry, removing the WHERE clause will SUM all the fields yes, but it will SUM the fields and then duplicate it by the first qty value it finds, in this case 3. So with the values 2.00 | 3 and 1.50 | 2, it will add 1.50 to 2.00 witch is 3.50 and duplicate by 3 witch is 7. The value i need is 9.00.

I need the script to get the total value for a row and then add all the rows together to get a single total value. The WHERE clause is there to get the value for that row as it is inside the { }.

[dennispopel]

Although I do not clearly understand what are you trying to achieve, but in your case you do not need the SUM aggregator at all since you loop thru every record you are SUMming. Simply:

$select = "SELECT * FROM table";
$data = mysql_db_query('database', $select) or die("DIE");
$sum = 0;

while($row = mysql_fetch_array($data))
{
$uid = $row['uid'];

$q = mysql_query("select value, qty from table where uid=$uid");
$r = mysql_fetch_assoc($q);
$sum += $r['value'] * $r['qty'];
}

echo $sum;