چاپ مقدار بدست آمده این کوئری

[abbas3zaar]

این کد




$query = mysql_query("SELECT SUM(total_price) FROM orders WHERE DATE(created) = '".date('Y-m-d')."' ");

if($query){

$data = mysql_fetch_assoc($query);

var_dump($data);

}


خروجیش:

array(1) { ["SUM(total_price)"]=> string(5) "18500" }



اون 18500 رو چجوری echo کنم؟

[thacker]

$query = mysql_query("SELECT SUM(total_price) AS totalPrice FROM orders WHERE DATE(created) = '".date('Y-m-d')."' ");

if($query){

$data = mysql_fetch_array($query);

echo $data['totalPrice'];

}