[ic] Re: Ebay Feed - MySQL Query Problem

["Gert van der Spoel" <suppressed>]

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
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users