Well Sir I have been living in Mr.and Mrs. PHP and SQL 's home the last two days. Reading and trying different angles to the code above with no success.
First off, no insult to you. That bit above taught me about joins and conditional statements and much more. And I'm still looking at it.
In any case, it doesn't appear to have primary / foreign keys.
SELECT * FROM ig_deals AS d INNER JOIN ig_categories AS c INNER JOIN x AS ig_city ON ig_deals.shop_id = ig_deal_shops.shop_city_idWHERE ig_category.cat_type != 1 AND ig_deals.deal_category = 4
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in all_deals.php on line 42
$sql = 'SELECT * FROM ig_deals AS d INNER JOIN ig_categories AS c INNER JOIN x AS ig_city ON ig_deals.shop_id = ig_deal_shops.shop_city_id';
41. $result = mysql_query($sql);
No sorry there aren't any - I wasn't sure what they were called, so I left them out intially and forgot to include some dummy fields on posting :(