how to fetch the result of a select count statement?

[Stephane Legault]

I do a lot of select in many statement and fetch the result on a array as
needed. But now one of my staement is a "select count() from ...". How can
I get the value of this statement?