calculate each field records...need help!

[bos]

------------------------------------
time              | id | cash
------------------------------------
2006-10-07  | 1  | 24000
2006-10-08  | 1  | 140000
------------------------------------

How him so that the calculation field 'cash' can be
380000,what the SQL or PHP order?..

$df = mysql_query("SELECT * from saldo where id = '1'");
if (!$df) {
echo 'Could not run query1: ' . mysql_error();
exit;
}

while ($sh = mysql_fetch_array($df))
{
$tk = $sh[1] + $sh[1];
echo $tk;
}

But results above like;
480000160000
That I wanted results of the total number field record 'cash' to one,just like this
380000

[printf]

You can do the math in your query!

[code]$query = mysql_query ( "SELECT SUM(cash) AS total FROM saldo where id = 1" );

$result = mysql_fetch_assoc ( $query );

echo $result['total'];[/code]


me!

[bos]

$df = mysql_query("SELECT SUM(\x63\x61\x73\x68) AS total FROM vk_saldo where id = '1'");
if (!$df) {
echo 'Could not run query1: ' . mysql_error();
exit;
}

greats !! its absolute worked...

The order went correctly, you indeed the champion in the SQL language

ownz by printf.....


thx 4 reply!!

[fenway]

Not that prinf's solution wasn't entirely correct, but I'm confused as to why PHP "guessed" the variable type wrong... aren't they weakly typed?