What's Wrong with this SELECT

[rseigel]

SELECT * FROM ps_product WHERE ps_product.active = '1' AND ps_product.ean13 = '' AND ps_product.id_category_default != '73'

Works perfectly in phpMyAdmin yet when I put it in a QUERY

$result = mysqli_query($con,'SELECT * FROM ps_product WHERE ps_product.active = '1' AND ps_product.ean13 = '' AND ps_product.id_category_default != '73'')
    or die(mysqli_error());

it fails. 

 

Thanks,

 

Ron

[Barand]

This is your query

'SELECT * FROM ps_product WHERE ps_product.active = '

You need to use double quotes to enclose the query, not single quotes.

[rseigel]

I'm such a moron....thanks for that catch.