[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