Can anyone tell me what in this query could create a PHP bug but good when I execute the query on SQL Yog.
Thanks all for your help.
$myQuery = "SELECT merchants.PK_MERCHANTS_UID AS bob,merchants.MERCHANTS_NAME as bob1,discounts.PK_DISCOUNTS_UID as bob2,discounts.DISCOUNTS_DESC as bob3 FROM merchants,discounts INNER JOIN merchants_discounts ON merchants.PK_MERCHANTS_UID = merchants_discounts.FK_MERCHANTS_UID and discounts.PK_DISCOUNTS_UID = merchants_discounts.FK_DISCOUNTS_UID GROUP BY merchants.PK_MERCHANTS_UID";
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\ on line 354
Thanks all for your help.
$myQuery = "SELECT merchants.PK_MERCHANTS_UID AS bob,merchants.MERCHANTS_NAME as bob1,discounts.PK_DISCOUNTS_UID as bob2,discounts.DISCOUNTS_DESC as bob3 FROM merchants,discounts INNER JOIN merchants_discounts ON merchants.PK_MERCHANTS_UID = merchants_discounts.FK_MERCHANTS_UID and discounts.PK_DISCOUNTS_UID = merchants_discounts.FK_DISCOUNTS_UID GROUP BY merchants.PK_MERCHANTS_UID";
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\ on line 354