Thank you for this.

I created the global exactly as you wrote it and called it product_select.

In the template I call the global like this:
<%product_select('product_code', 'TA')%>

The global returns a select field, but it's empty. So it looks as if the select in the global is returning an empty data set.

Here's the equivalent query in phpmyadmin:

SELECT product_code, product_name
FROM `Product_Category` WHERE
category_code = 'TA'

which returns 29 rows

product_code product_name
BE Belt Leather
BL Bag & Luxury Goods Leather
BO Bookbinding Leather
etc etc

I must be doing something daft. Can you see what I'm doing wrong?

thanks
Tim Ault
Oxford UK