When I access MySQL using
SELECT Count(*)
FROM TABLE
WHERE CONDITION

How do I get the count result from the query.
I've $row["count"] but it doesn't contain anything.

Also, I'm presuming that a count query is a lot quicker than a query that gets actual records, would I be right????