I'm wondering why my MySQL `COUNT(*)` query always results in `->num_rows` to be equal `1`.

```
$result = $db->query("SELECT COUNT( * ) FROM u11_users");
print $result->num_rows; // prints 1

```

Whereas fetching "real data" from the database works fine.

```
$result = $db->query("SELECT * FROM u11_users");
print $result->num_rows; // prints the correct number of elements in the table

```

What could be the reason for this?