[RESOLVED] simple help with PDO, please

steamPunk

What do I need to do to check the number of results obtained (or not) if I use the following code ?

    $sql ="SELECT etc";
    $conn = new PDO(vars etc);
    $sth = $conn -> prepare($sql);
$sth->execute();
$res = $sth->fetchAll();
$sth->closeCursor();

I tried doing count($res) but that doesn't seem to be correct - there must be an inbuilt method for returning the number of rows, like mysql_num_rows()

can someone point me in the right direction please ?

thanks

laserlight

steamPunk wrote:
I tried doing count($res) but that doesn't seem to be correct

How do you know that it is not correct?

steamPunk wrote:
there must be an inbuilt method for returning the number of rows, like mysql_num_rows()

You could just select the count in the query.

steamPunk

laserlight;10928840 wrote:
How do you know that it is not correct?

Because when I used it to check if there was a non-existant email already in the DB the count was =1 !

laserlight;10928840 wrote:
You could just select the count in the query.

true ... I hadn't thought of doing that

thanks !

steamPunk

that works fine 😃