Code: Select all
$resultuk = mysql_query ("SELECT id FROM products WHERE romancode = '$rowcat->romancode' AND paintedalternative IS NOT NULL", $dbuk);
var_dump($resultuk);
print_r($resultuk);This should be showing nothing. When I do a 'count' of the results rows, it should be coming up as zero.
This page has a database connection to it's 'home' database, and is specifically querying it with ", dbsup, and that works without errors. So I don't think it is the db conn, as it's not erroring the connection.
If I query this in phpmyadmin, it comes up with zero rows.