// 短信息
$SMSNumSQL = "SELECT COUNT(*) AS Num FROM ".TABLE_MESSAGE." WHERE message_send_to='$_SESSION[sessLoginName]'";
$newSMSNumSQL = "SELECT COUNT(*) AS Num FROM ".TABLE_MESSAGE." WHERE message_send_to='$_SESSION[sessLoginName]' and message_stat='Y'";
$SMSNum = $DB->result($DB->query($SMSNumSQL),0);
$newSMSNum = $DB->result($DB->query($newSMSNumSQL),0);
就这两个合成一个???谁有办法?????
$SMSNumSQL = "SELECT COUNT(*) AS Num FROM ".TABLE_MESSAGE." WHERE message_send_to='$_SESSION[sessLoginName]'";
$newSMSNumSQL = "SELECT COUNT(*) AS Num FROM ".TABLE_MESSAGE." WHERE message_send_to='$_SESSION[sessLoginName]' and message_stat='Y'";
$SMSNum = $DB->result($DB->query($SMSNumSQL),0);
$newSMSNum = $DB->result($DB->query($newSMSNumSQL),0);
就这两个合成一个???谁有办法?????
一条是message_stat='N'的数量
一条是message_stat='Y'的数量
两者之和为总数如果数据库支持条件控制,比如mysql可写作
"SELECT COUNT(*) AS Num, SUB(if(message_stat='Y',1,0) AS num1 FROM ".TABLE_MESSAGE." WHERE message_send_to='$_SESSION[sessLoginName]'"
SUB ===> SUM
===>
SUM(if(message_stat='Y',1,0))少了个闭括号,你也没看出来吗?