[ic] Re: Ebay Feed - MySQL Query Problem

Gert van der Spoel ic at 3edge.com
Sat May 13 10:27:02 EDT 2006


William Fiore writes: 

> Gert van der Spoel Writes: 
> 
>>$query = "SELECT * FROM products WHERE sku = ANY (SELECT sku FROM inventory
>>WHERE quantity > 5) AND date_added >= curdate()";
> 
> Gert, 
> 
> I tried this query and received the following error: 
> 
> Warning:  mysql_fetch_object(): supplied argument is not a valid MySQL
> result resource 
> 
> Any ideas??

I suggest you try the command on the mysql command line first to see if you 
get any results. AFAIK this response means that you got an empty result set 
returned (perhaps no products added today - no products with more than 5 in 
stock?) ... 

If this is the case then you will have to catch this error. 

CU, 

Gert


More information about the interchange-users mailing list