PDO fetch and fetchAll with conditional statement not working

Question

his is not working can anyone help please?

(count($stmt->fetchAll()) > 1) ? $result = $stmt->fetchAll() : $result = $stmt->fetch();

print_r($result);

Answer 1

All the fetchXYZ methods advance the underlying cursor, so once you've called them, you cannot "go back" and get the same rows again.

You could redo your condition in-memory, after calling fetchAll() only once:

$result = $statement->fetchAll();
if (count($result) == 1) {
    $result = $result[0];
}