计算mysql php中表的总值 [英] calculate the total value of a table in mysql php

问题描述

嗨


我有一个包含数值的mysql数据库。



例如：



affID l金额



MW001 5

MW004 10

MW001 11

MW001 15

MW004 20



我需要的是一个查询的帮助，可以计算总数佣金MW001的金额。



例如：MW001 = 31



目前它获得通过登录会话获得affID的价值。



这就是我所拥有的并且它不起作用：



$ sql =SELECT affID，COUNT（*）as c FROM taffiliate WHERE AffCommision ='。 $ _SESSION ['affID']。 ';

$ result = mysql_query（$ sql）;

$ row = mysql_fetch_array（$ result）;

echo $ row [ 'c'];

Hi
I have a mysql database that contains numeric values.

Example :

affID l Amount

MW001 5
MW004 10
MW001 11
MW001 15
MW004 20

What i need is help on a query that will caluculate the Total Amount for the affID MW001.

So for example : MW001 = 31

At the moment it gets the value of the affID through a login session.

this is what i have and it is not working :

$sql = "SELECT affID, COUNT(*) as c FROM taffiliate WHERE AffCommision = '" . $_SESSION['affID'] . "'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row['c'] ;

推荐答案

sql =SELECT affID，COUNT（*）as c FROM taffiliate WHERE AffCommision ='。

sql = "SELECT affID, COUNT(*) as c FROM taffiliate WHERE AffCommision = '" .

_SESSION ['affID']。 ';

_SESSION['affID'] . "'";

result = mysql_query（

result = mysql_query(

这篇关于计算mysql php中表的总值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！