Re: [ic] Ebay Feed - MySQL Query Problem

["Gert van der Spoel" <suppressed>]

William Fiore writes: 

> Hi, 
>
> I have created a feed in PHP to submit my products to Ebay. My original
> feed worked fine but did not filter products. It looked like: 
>
> $query = "SELECT * FROM products WHERE 1; 
>
> Obviously I do not want all 5,000 of my products submitted to Ebay so I
> would like to modify the query to only list new products (listed in the
> last 90 days) and that I have at least (5) of in stock. Even better, would
> be products that have been purchased before and appear in my "orderline"
> table. 
>
> So far I have: 
>
> $query = "SELECT * FROM products WHERE sku = (SELECT sku FROM inventory
> WHERE quantity > 5) AND date_added >= curdate()"; 


$query = "SELECT * FROM products WHERE sku = ANY (SELECT sku FROM inventory
WHERE quantity > 5) AND date_added >= curdate()"; 

CU, 

Gert
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users