Count the number of rows returned

bettermysql-rowCount.php

<?php
  // Assuming that database connection is already open
  // Prepare statement
  $stmt = $db->prepare("SELECT user, email, country FROM users WHERE id > 1000");
  $stmt->execute();
  
  // Get results
  if($stmt->rowCount() > 0) {
    // One or more rows returned, start iteration through set
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
      // Do something for each row
    }
  } else {
    // No rows returned
  }
?>