prepare multidimensional array from PHP using jQuery autocomplete

extending my previous post, link below:
https://www.webdeveloper.com/d/390686-multiple-columns-in-one-input-field-using-jquery-autocomplete

[code]
if ($request == 2) {
$id = $_POST[‘id’];
$sql = “SELECT * FROM MY_COMPONENTLIST WHERE id=”.$id;
$result = mysqli_query($con, $sql);
$AncillaryPricing_arr = array();
while ($row = mysqli_fetch_array($result)) {
$id = $row[‘id’];
$codeANCILLARY = $row[‘matDes1’];
$mat50ANCILLARY = $row[‘matCost1’];
**//***************************
//***************************
$codeANCILLARY = $row[‘matDes2’];
$mat50ANCILLARY = $row[‘matCost2’];
.and
.so on
.until 5
//***************************
//*****************************
$unitsANCILLARY = $row[‘units’];
$AncillaryPricing_arr[] = array(
“id” => $id,
“codeANCILLARY” => $codeANCILLARY,
“mat50ANCILLARY” => $mat50ANCILLARY,
“unitsANCILLARY” => $unitsANCILLARY
);
}
echo json_encode($AncillaryPricing_arr);
exit;
}
[/code]

dear members i think my problems lying here as shown above, when trying to set up a jQuery autocomplete that uses results from a PHP MySql query.

please help or advise , how can i achieve this .

Also in #PHP _↴