$query = $handler->query('select * from guestbook');
if($query->rowCount()) {
echo "Number of rows: ", $query->rowCount(),"
"; while($r = $query->fetch(PDO::FETCH_OBJ)){
echo $r->name, " ", $r->message, " ", $r->posted, "
"; }
} else {
echo "No Results";
}



Page 1
SQLSTATE[HY000] [1045] Access denied for user 'app_user'@'localhost' (using password: YES)

Part 8 of 8 - Row count.
Using the rowCount() method.