variable with sql count results

[a4toronto]

i have the following line of code:
$user=$DB_site->query("SELECT COUNT(*) FROM post WHERE userid='$userid' AND review=1");

how do i get access to the count results?

echo $user displays "resource id#12"

[a4toronto]

just to clarify, the goal of my code is to update the contents of a field with the number of rows that have the "review" flag set to 1.

[Logician]

$user=$DB_site->query("SELECT COUNT(*) as posts FROM post WHERE userid='$userid' AND review=1");

echo number_format($user['posts']);

[Admin]

You also need to use $DB_site->query_first() instead of query().