php - Sum table1 $date1 和 $date2 之间 AND 用户名等于 $user

Question

你好，我对这个总和选择有一些问题，有人知道这有什么问题吗，看来我没有得到任何结果

$result = mysql_query("SELECT SUM(total)   
FROM table1 where   date BETWEEN '".$date1." 00:00:00' AND '".$date2." 23:59:59' and  username = ".$user."");  
 while($row=mysql_fetch_array($result))  
{  $sum = $row['SUM(total)'];}

Answer 1

尝试

$query = "SELECT SUM(total) AS result   
          FROM table1 
          WHERE DATE(date) BETWEEN '$date1' AND '$date2' 
          AND username = '$user'"; 

$con = \\your db connection string
$result = mysql_query($con,$query);

while($row=mysql_fetch_array($result))  
{$sum = $row['result'];}