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

[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'];

 

}