$sql = "SELECT COUNT(*) AS total from Members"; $result = $conn->query($sql); $data = $result->fetch_assoc(); echo $data['total'];