回复列表
3.
$sql=$empire->fetch1("SELECT SUM(jin3) from {$dbtbpre}ecms_ali");
$data=$sql;
模板文件调用 <?php $data[0] ?> 正常显示
4.
$sql=$empire->fetch1("SELECT SUM(jin3) from {$dbtbpre}ecms_ali where DateDiff(mm,VoucherDate,getdate())= 1");
上一个月的信息统计该怎么写呢? 这么写显示错误
6.
错误
SQL 查询: 文档
SELECT SUM( price3 ) FROM phome_ecms_blpyp WHERE DateDiff( mm, VoucherDate, getdate() ) =1
MySQL 返回:文档
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate())=1' at line 1
这个错误是什么意思?