我有这段代码,它显示了截至当前日期的总销售额,但是它的展示方式如下:
有没有办法以这种方式显示总销售额:7,日期:2014-01-25?
Array (
[Date] => 2014-01-25
[TotalSales] => 7
)
有没有办法以这种方式显示总销售额:7,日期:2014-01-25?
<?php
$host = 'localhost';
$user = 'root';
$passwd = '';
$database = 'p_database';
$connect = mysql_connect($host,$user,$passwd) or die("could not connect to database");
$query = "SELECT DATE(order_time) AS Date, SUM(Quantity) AS TotalSales
FROM ss_orders,ss_ordered_carts
WHERE DATE(order_time) = DATE(NOW())
group by date;";
mysql_select_db($database,$connect);
$result = mysql_fetch_assoc(mysql_query($query));
print_r($result);
?>
mysql
库已经被弃用。为什么不打印出错误信息呢? - Ed Heal