Menu
[COLOR=Navy] if(isset($_POST[‘BtnUpdate’])) {
$id = $_POST[‘pid’]; // form textfield
$pqty = $_POST[‘pqty’]; // form textfield
$nqty = $_POST[‘list’]; // form textfield
$cqtys = (is_array($nqty)) ? implode(‘,’, $nqty) : $nqty;
echo ‘changed: ‘.$cqtys;
$ids = (is_array($id)) ? implode(‘,’, $id) : $id;
echo ‘id: ‘.$ids;
$oqty = (is_array($pqty)) ? implode(‘,’, $pqty) : $pqty;
echo ‘Original: ‘.$oqty;
$obj_db->query(“update basket set b_quantity IN($cqty) where session=’$code’ and p_id IN($ids) and b_quantity IN($oqty)”);
} [/COLOR]
it returns an error message in query