How to retrieve SUM() result?

[gabrielk]

Hi Folks,

I'm using the following query:

SELECT SUM( personen )
FROM boekingen
WHERE optie = 0 AND datum = '20031803'

In the following code:

        

$query = "SELECT SUM( personen ) 
    FROM boekingen WHERE optie = 0 AND datum = '20030318'";
    mysql_select_db("reservering");
    $result = mysql_query($query);

if ($result) {
    echo "$result";
                  }

But this returns: Resource id #2

How to retrieve the sum value?? (The query works in phpMYAdmin, so the query is okay)

Thanks in advance.

Gabriël.

[Pig]

SELECT SUM(personen) AS sum_personen

you could do it that way, I think. Haven't had my coffee yet though.

[cgraz]

yes, you can do it like that.

then when you fetch the array, (lets say into $foo), you access it using

$foo["sum_personen"]

IF you don't do the AS sum_personen and just leave it at

$query = "SELECT SUM(personen)
FROM boekingen WHERE optie = 0 AND datum = '20030318'";

If i remember correctly, you can access it like this

while($row = mysql_fetch_assoc($query)) {
   echo $row[sum(personen)];

// not sure on that one. It may even be $row["sum"]["personen"]
// you'll have to test it to be sure

Cgraz

[tomhath]

$query = "SELECT SUM( personen ) 
    FROM boekingen WHERE optie = 0 AND datum = '20030318'";
    mysql_select_db("reservering");

$result = mysql_query($query) or die (mysql_error() );

$row = mysql_fetch_array($result)

echo $row[0];

[khaldryck]

i usually do that with mysql_result()
(whenever i use only a count, a sum or function likewise)

$query = "SELECT SUM( personen ) 
FROM boekingen WHERE optie = 0 AND datum = '20030318'";
mysql_select_db("reservering");

$result = mysql_query($query) or die (mysql_error() );

$sum=mysql_result($result,0);
echo $sum;