count without Active Record

[eluser]introvert[/eluser]
Hello,

What is the easiest // the most resource friendly way to count results?

Code:

$query = $this->db->query("SELECT count(*) FROM $this->table WHERE site_id = $this->site_id AND permalink = '$unique'");

How to access count variable?