SQL the same table, PHP query the sum of 2 columns of data and then output

Calculate the sum of order quantities

$query_num"SELECT SUM(order_num) from hcf_order_db where order_id = XXX";$arr_qn = mysqli_query($dbc,$query_num);list($sum)=mysqli_fetch_row($arr_qn);

Calculate the sum of the order Amount

$query_amount"SELECT SUM(order_amount) from hcf_order_db where order_id = XXX";$arr_qm = mysqli_query($dbc,$query_amount);list($sum2)=mysqli_fetch_row($arr_qm);

Then there is the PHP output:

<tdclass='font-songti'align='center'>
    
     echo$sum?>
    
     td><tdclass='font-cali'align='right'>
    
     echo$sum2?>
    
     td>

If the output is followed by a number of decimal places, you can set the value's property to Decimal (16,1) in SQL.
The next 1 is the reserved 1-bit decimal point.

The above describes the SQL the same table, PHP query the sum of 2 columns of data and then output, including the aspects of the content, I hope to be interested in PHP tutorial friends helpful.

