query works fine on console but not with PHP - why?
| From: | Aaron Wolski | Date: | Sun, 03 Aug 2003 13:59:42 +0000 |
| Subject: | query works fine on console but not with PHP - why? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29642@lists.php.net to get a copy of this message | ||
Hi guys,
I have the following query which returns FINE through the console but
not in PHP
select t.id, t.colour, t.colourID, t.price, t.type, g.thread_index,
g.groupNameUrl FROM kcs_threads t LEFT JOIN kcs_threadgroups g ON t.id =
g.thread_index WHERE g.groupNameUrl = '0-500'
The error I am getting on the browser is:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
result resource in http://www.martekbiz.com/KCS/utils.inc on line 52
Anyone have an idea as to what it up?
Thanks!
Aaron