MySQL query returns only one row in pdo

Question

My MySQL query is displaying just one row (instead of all of the rows), but when I do a COUNT on the query, it shows the correct number of rows in the query. What seems to be the problem here?

$sql5 = "SELECT m.*, i.*, COUNT(*) AS num, m.id AS m_id FROM members m JOIN roommate_seek i ON m.id = i.member_id
              WHERE _school = :school AND i.category = :category";

foreach ($db->query($sql5, array('school' => $_GET['school'], 'category' => $category)) AS $result3)
{
    echo "{$result3['m_id']}";
}

Vatev · Accepted Answer · 2015-07-15 15:27:34Z

4

You are using an aggregate function (COUNT) without GROUP BY. In that case it is suppose to return exactly one row.

answered Jul 15, 2015 at 15:27

Vatev

7,5801 gold badge36 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query returns only one row in pdo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related