prepare("SELECT COUNT(id) FROM alarm WHERE uid =?")){ $stmt -> bind_param("i", $userid); $stmt -> execute(); $stmt -> bind_result($count); $stmt -> fetch(); $stmt -> close(); } ?>