$sql = "update tbl_noti set status = 'read'"; $result = $conn->query($sql); $row = $result->fetch_assoc(); $count = $result->num_rows; echo $count; $conn->close();