How to make "Select an account ..." using symfony and propel?

Question

I am trying to make a very simple sql query like this for the propel criterion:

SELECT count(id_user) FROM myTable WHERE id_page = 5

I did not find any documentation information.

Do you have an idea?

Answer 1

$c = new Criteria();
$c->add(myTablePeer::ID_PAGE,5);
$count = myTablePeer::doCount($c);

Answer 2

If you want to issue SELECT COUNT (*) based on the current ModelCriteria, you can also do

$yourCriteria->count();

This will return you the number of results.