Here is my sample code:
$categoryID = 1;
$productCode = 's%';
$db = new PDO('mysql:host=localhost;dbname=my_database',
$stmt = $db->prepare("SELECT * FROM products WHERE categoryID = :categoryID, AND productCode like :productCode");
$stmt->bindParam(':categoryID', $categoryID, PDO::PARAM_INT);
$stmt->bindParam(':productCode', $productCode, PDO::PARAM_STR);
$results = $stmt->fetchAll();
echo '-->Number of Records: '.count($results).'<p />';
I know for a fact the result set returned should be 2 records, but somehow I keep getting zero records. Can anyone look at my code and tell me what I'm doing wrong?
Thanks in advance.