num_row with PDO

Date: Fri, Jun 10, 2011

There is no num_row() function for PHP PDO

Here are my two solutions:

One with prepare & execute:

    db->prepare($sql);
    $sth->execute(array($key));
    $rows = $sth->fetch(PDO::FETCH_NUM);
    echo $rows[0];

One with query:

    db->query($sql);
    $row = $result->fetch(PDO::FETCH_NUM);
    echo $row[0];