I wrote this code in native and running …
$qryDetTestCat = " SELECT qdetInv.qctestcatid, qdetInv.qctestcode, qdetInv.qctestname, qdetInv.isfield,
qdetInv.spesifikasi, qdetInv.aql, qdetInv.hasil, qdetInv.note
FROM vci.qcreceiptdetailinventory AS qdetInv
WHERE qdetInv.qrno = ‘" . $qrno . "’
AND qdetInv.inventorycode = ‘" . $inventorycode . "’
AND qdetInv.qctestgroupid = ‘" . $qctestgroupid . "’
AND qdetInv.qctestcatid IS NOT NULL
AND qdetInv.iscat = ‘1’
AND qdetInv.iscustom = ‘" . $DetGroupCustom . "’
ORDER BY qdetInv.qctesturutan ASC";
$sqlDetTestCat = mysql_query($qryDetTestCat);
$cntDetTestCat = mysql_num_rows($sqlDetTestCat);
if($cntDetTestCat > 0){
while($rowTestCat = mysql_fetch_array($sqlDetTestCat)){
$qctestcatid = $rowTestCat[‘qctestcatid’];
$qctestcatcode = $rowTestCat[‘qctestcode’];
$qctestcatname = $rowTestCat[‘qctestname’];
$qctestcatisfield = $rowTestCat[‘isfield’];
$spesifikasiCat = $rowTestCat[‘spesifikasi’];
$aqlCat = $rowTestCat[‘aql’];
$hasilCat = ($rowTestCat[‘hasil’] == ‘0’) ? ‘’ : $rowTestCat[‘hasil’];
$noteCat = $rowTestCat[‘note’];
but i want to run this logic in php maker … what functions should be changed to get the same output?
thank you