Posted by KathyW on February 29, 2008 at 12:30am
New member with a question.
I have an eCommerce (5.x) shop with a selection of products. In another section of my web site I want to extract the names (title) and prices (price) of only a few products to use in a WebForm form.
Is there a better or preferred way to do this other than writing some php and a direct MySQL query like:
select node.title, ec_product.price from node, ec_product where node.nid = ec_product.nid and node.title like '%Line Filter%';
I'd rather not hard code the products in the form as the brands and prices may change and I'd rather only have to maintain it in one place - the (eCommerce) product page.
Thanks.
