Addition of rows in database...

[subhomoy]

hii everyone

how to add the values of rows in a database.... I have added the code of my database table

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `money` int(11) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

 

And i have some rows like

(1,peter, $94)

(2,John,$16)

....

....

....

....

....

i want to add those values (i.e their money) and shows like [ total money = $110]...

I have done few queries like

SELECT id,SUM(money) FROM users

and

 mysql_query("SELECT * FROM `users` SUM `money`  WHERE id='$id'");

But nothing seems to work out... Any help guysss....

 

Thanks in advance...

[Barand]

just

SELECT SUM(money) FROM users

[subhomoy]

To Barand

SELECT SUM(money) FROM users

can you please tell me in detail....

I have done like this...

 

<?php

$raja = SELECT SUM(money) FROM users

echo "$raja";

?>

But it shows an error....

if possible give the code...

[Barand]

  <?php
    $res = mysql_query("SELECT SUM(money) FROM users");                // send query to db server
    
    $row = mysql_fetch_row($res);                                     // get first row from the resultset
    
    echo $row[0];                                                     // echo first column of the row
  ?>

 

I suggest you search for mysql tutorial.

[subhomoy]

To Barand

  <?php

    $res = mysql_query("SELECT SUM(money) FROM users");                // send query to db server

   

    $row = mysql_fetch_row($res);                                    // get first row from the resultset

   

    echo $row[0];                                                    // echo first column of the row

  ?>

 

Thanks it really helpsss....... Thanks once again..