prepare("SELECT * FROM friends WHERE receiverid = :id AND status = 0"); $incomingFRs->bindParam(":id", $userid, PDO::PARAM_INT); $incomingFRs->execute(); if(!$incomingFRs->rowCount()){ die(); } while ($row = $incomingFRs->fetch(PDO::FETCH_OBJ)) { $friends = $pdo->prepare("UPDATE friends SET status = 1 WHERE requesterId = :friendid AND receiverId = :id"); $friends->bindParam(":friendid", $row->requesterId, PDO::PARAM_INT); $friends->bindParam(":id", $userid, PDO::PARAM_INT); $friends->execute(); }