I am using the query for the grand total of the adjusted price.
Here's my query and it returns nothing:
Code: Select all
$sql = "SELECT service_ordered, admin_comments, adj_price, sum(adj_price) as tot_price
from services_ordered where services_ordered.client_id=$_POST[c_id]
group by service_ordered";
Any idea!