PHP Using PHP with MySQL Limiting Records in SQL Queries Using LIMIT with Offset

Using LIMIT with Offset not working

HELP! I have all the functions working except the get_products_subset. I only get a blank screen with on error message when I try to access the shirts page.

function get_products_subset($positionStart, $positionEnd) { $offset = $positionStart - 1; $rows = $positionEnd - $positionStart + 1;

require(ROOT_PATH . "inc/database.php");

try {
    $results = $db->prepare(
        "SELECT name, price, img, sku, paypal
        FROM products 
        ORDER BY sku 
        LIMIT ?, ?"); 

       $results->bindParam(1, $offset, PDO::PARAM_INT);
       $results->bindParam(2, $rows, PDO::PARAM_INT);
       $resilts->execute();

} catch (Exception $e) {
    echo "Data could not be retrieved from the database.";
    exit;
}

$subset = $results->fetchAll(PDO::FETCH_ASSOC);

return $subset;

}