然后将结果值插入数组并求出它们的和。=mysql_fetch_assoc($result)){ $array=$row; echo $sum;这只返回数组中的项,而不是总和。Ps:我之前在这里试过了,但它减半了正确的结果:
$result=mysql_query("SELECT items FROM m
就像这样is_delivered = 'yes'我试过了,但结果不对。SELECT * FROM invoices i INNER JOIN (SELECT invoice_id, SUM(price) AS total FROM invoice_products p )AS t ON t.invoice_id = i.invoice_id;
我在mysql方面不是很好,但我试过了。