get total in mysql query

[otixz]

Hi,

 

I need a msyql query that will calculate for the total of a given condition....

 

select sum(select amount from tblinquiries where inq_date = '22/04/2008') from tblinquiries

 

what I want to do is to get the TOTAL of all the amount of 22/4/2008 data from my tblinquiries table.

please help...what query can I use?

[paul2463]

you could do it in php

 

$total = 0;
$query = "SELECT amount FROM tblinquiries WHERE inq_date = '22/04/2008'";
$result = mysql_query($query) or die ("Error in query " . mysql_error());
while ($row = mysql_fetch_assoc($result)
{
$total = $total + $row['amount'];
}
echo $total;

 

[Lumio]

you could do it in php

 

$total = 0;
$query = "SELECT amount FROM tblinquiries WHERE inq_date = '22/04/2008'";
$result = mysql_query($query) or die ("Error in query " . mysql_error());
while ($row = mysql_fetch_assoc($result)
{
$total = $total + $row['amount'];
}
echo $total;

Why don't you show him mysql_num_rows?

 

The easiest way with MySQL is

SELECT COUNT(amount) as totalCount FROM tblinquiries WHERE inq_date = '22/04/2008';

[paul2463]

i always thought that sum() had to be used with a groupby command as well

 

I now know different

[Lumio]

You are right it was COUNT instead of SUM.

[otixz]

Hi,

 

The COUNT was just able to get the number of how many data are in the database.

 

It did not calculate the TOTAL SUM of the amount in the database.

 

 

[AndyB]

http://www.tizag.com/mysqlTutorial/mysqlsum.php