Query working on MySql Querier not on PHP

[McKaulick]

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\

http://www\grabaloo\grabaloo2in.php

on line 354

 

[vacunita]

Have you tried asking it why its not working:

mysql_query($myQuery) [red]or die(mysql_error())[/red];

Maybe then it will tell what problem its having with the query.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[McKaulick]

Hello Vacunita,

It actually gives the same error message when I add the or die.

Any thoughts?

Thanks

 

[jpadie]

try a bit further up in the connect or select_db functions.

 

[McKaulick]

Hey thanks guys for you help...

I found the problem, I am actually building the query in a function and I was just forgetting to return the result. :-s Thanks anyway... Soo tired, I better stop now.

Thanks