Why does the query return only one result?

Question

PHP

Request:

$times= $sql->query("SELECT * FROM datetime WHERE date='2014-05-24'")->fetch_array();

date in the database is of type "date".
The "datetime" table has 2 rows with the same date column value. The script returns only one result (the one with the larger id). What could be the problem?

Answer 1

$result = $sql->query("SELECT * FROM datetime WHERE date='2014-05-24'");
while ($row = $result->fetch_assoc()) {
    $times[] = $row;
}