Printing an [] from a mysql table

[lurtnowski]

I have a mysql table I run a select on

$sql = 'SELECT optionName FROM providers_options WHERE providerID = :id';
$prepare = $conn->prepare($sql);

$parameters = array(
':id' => $id
);

$prepare->execute($parameters);
$provider_options = $prepare->fetch(); 

W"hen I print_r($provider_options) to see the resulting array, I only get 1 result, but when I run t he query, I get 4.
Is $provider_options not the resulting array?
what is?

[phpRob]

@lurtnowski

$provider_options = $prepare->fetch();

No, it isn’t the array. You just got the first row. You need to iterate through all rows. Something like this…

while($provider_options = $prepare->fetch()){
   print_r($provider_options);
}

[droopsnoot]

Or, as it’s PDO, you could use fetchAll() to get the entire result set into an array.