MySQL SUM Query

[DanielWhite]

Hey,

 

Does anyone know why this won't work:

 

mysql_query("SELECT SUM(InkCosts) FROM Stats WHERE Month='$MONTH' AND Year='$YEAR'"); 

 

The table name is correct,

The $MONTH variable is working.

The $YEAR variable is working.

The InkCosts is the right field name.

 

The code below;

$INK = mysql_query("SELECT SUM(InkCosts) FROM Stats WHERE Month='$MONTH' AND Year='$YEAR'"); 
echo $INK;

Prints this:

Resource id #4

 

 

Thank you,

Daniel White.

[hitman6003]

You have to get the result of your query out of the "Resource" returned by the query...

 

$INK = mysql_query("SELECT SUM(InkCosts) FROM Stats WHERE Month='$MONTH' AND Year='$YEAR'"); 
echo mysql_result($INK, 0);

[ohdang888]

or:

$INK = mysql_query("SELECT SUM(InkCosts) FROM Stats WHERE Month='$MONTH' AND Year='$YEAR'");

$INK = mysql_fetch_array($INK);

$INK = $INK['SUM(InkCosts)'];

echo $INK;

 

[DanielWhite]

Thank you very much  :-)

 

I'm using this one:

echo mysql_result($INK, 0);