使用php从网络访问mysql数据库,如何使用php从mysql数据库访问特定值？

这是我的php脚本,它从invoiceNo中选择invoiceNo不同的所有内容.

require 'init.php';

$query = 'SELECT * FROM `selected_items` WHERE invoiceNo IN ( SELECT DISTINCT ( invoiceNo) AS invoiceNo FROM selected_items ) GROUP BY invoiceNo;';

$res = mysqli_query($con, $query);

$result = [];

while ($row = mysqli_fetch_array($res)) {

array_push($result, [

'custInfo' => $row[0],

'invoiceNo' => $row[1],

'barcode' => $row[2],

'description' => $row[3],

'weight' => $row[4],

'rate' => $row[5],

'makingAmt' => $row[6],

'net_rate' => $row[7],

'itemTotal' => $row[8],

'vat' => $row[9],

'sum_total' => $row[10],

'bill_type' => $row[11],

'date' => $row[12],

'advance' => $row[13],

'balance' => $row[14],

]);

}

echo json_encode(['result' => $result]);

mysqli_close($con);

现在这个脚本给了我sum_total的第一个值,即它给了我数据库的第一行,我怎样才能得到最后一行.我是新手编程的任何建议或帮助表示赞赏.谢谢:)