如何在MySQL表单结果之前添加货币符号

Question

Hopefully I can better explain here than my title :(

Basically I've got the working mysql bootstrap table from the below site https://sourcecodesite.com/use-bootstrap-tables-display-data-mysql.html

I've set it up to display and fetch the results I require from my database, however I am trying to put a pound sign "£" before the sales table shows its result (as highlighted below)

enter image description here

I have tried to edit the code like below but haven't been successful, hoping someone here can help me :)

{
    field: 'sales',
    title: £'Job Price',
    sortable: true,
}

The generation code is as followed

<?php 
    require 'db.php';
        
        $sqltran = mysqli_query($con, "SELECT * FROM results_tbl_1 WHERE ENG_ID='".$_SESSION['username']."'ORDER BY RECORD_ID DESC") or die(mysqli_error($con));
        $arrVal = array();
        
        $i=1;
        while ($rowList = mysqli_fetch_array($sqltran)) {
                                 
                        $name = array(
                                'num' => $i,
                                'rec'=> $rowList['RECORD_ID'],
                                'call'=> $rowList['CALL_ID'],
                                'eng'=> $rowList['ENG_ID'],
                                'workcode'=> $rowList['Work_Code'],
                                'sales'=> $rowList['Sales'],
                                'paid'=> $rowList['How_Paid'],
                                'invoice'=> $rowList['Invoice Number'],
                                'date'=> $rowList['Date Completed']
                                
             
                                
                            );      


                            array_push($arrVal, $name); 
            $i++;           
        }
             echo  json_encode($arrVal);        
 

        mysqli_close($con);
?> 

</div>

Answer 1

See if this makes sense. We put the pounds symbol into a (hypothetical) field named "price."

$name = array(
    'num' => $i,
    'rec'=> $rowList['RECORD_ID'],
    'call'=> $rowList['CALL_ID'],
    'eng'=> $rowList['ENG_ID'],
    'workcode'=> $rowList['Work_Code'],
    
    'price' => '£' . $rowList['Price'], // MAYBE SOMETHING LIKE THIS
    
    'sales'=> $rowList['Sales'],
    'paid'=> $rowList['How_Paid'],
    'invoice'=> $rowList['Invoice Number'],
    'date'=> $rowList['Date Completed']
);

array_push($arrVal, $name); 

</div>