Jump to content

Archived

This topic is now archived and is closed to further replies.

bos

calculate each field records...need help!

Recommended Posts

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

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites
$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!!

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.