try{
$stmt = $conn->prepare("UPDATE products SET products.stock=:products.stock Where products.id=:product_id");
$stmt->execute(['products.stock'=>$newstock,'products.id'=>$productid]);
'''
= When I try to execute it it stated that SQLSTATE[HY093]: Invalid parameter number: parameter was not defined i dont know what is wrong
and here are the code for getting row ''' if(isset($_POST['id'])){ $id = $_POST['id'];
$conn = $pdo->open();
$stmt = $conn->prepare("SELECT *, orderlist.id AS orderlistid FROM orderlist LEFT JOIN usersc ON orderlist.user_id=usersc.id WHERE orderlist.id=:id");
$stmt->execute(['id'=>$id]);
$row = $stmt->fetch();
$pdo->close();
'''