I have a query (listed below) which when called through PHP returns no results however if I echo the query, cut and paste it into mysql and run it from the command line I get 1 result.
To me this makes no sense at all. What could the problem be?
PHP Code Query
$sql="SELECT w_jewellery_products.product_name AS product_name, w_jewellery_products.product_description AS product_description, w_jewellery_manufacturer.name AS manufacturer, w_jewellery_classes.display_name AS class, w_size.display_name AS size, w_material.display_name AS material, w_jewellery_series.display_name as series FROM w_jewellery_products, w_jewellery_manufacturer, w_jewellery_classes, w_material, w_weight, w_size, w_jewellery_series WHERE w_jewellery_products.product_code='".$_GET["product_code"]."' && w_jewellery_products.jcref_id=w_jewellery_classes.jcref_id && w_jewellery_products.material=w_material.unique_id && w_jewellery_products.weight=w_weight.unique_id && w_jewellery_products.size=w_size.unique_id && w_jewellery_series.jsref_id=w_jewellery_products.jsref_id && w_jewellery_series.jmanref_id=w_jewellery_manufacturer.jmanref_id";
Echo'd Query
SELECT w_jewellery_products.product_name AS product_name, w_jewellery_products.product_description AS product_description, w_jewellery_manufacturer.name AS manufacturer, w_jewellery_classes.display_name AS class, w_size.display_name AS size, w_material.display_name AS material, w_jewellery_series.display_name as series FROM w_jewellery_products, w_jewellery_manufacturer, w_jewellery_classes, w_material, w_weight, w_size, w_jewellery_series WHERE w_jewellery_products.product_code='5327' && w_jewellery_products.jcref_id=w_jewellery_classes.jcref_id && w_jewellery_products.material=w_material.unique_id && w_jewellery_products.weight=w_weight.unique_id && w_jewellery_products.size=w_size.unique_id && w_jewellery_series.jsref_id=w_jewellery_products.jsref_id && w_jewellery_series.jmanref_id=w_jewellery_manufacturer.jmanref_id;
Many Thanks
Rob
