Perfect - cheers for that, Worked perfectly!
The solution is to (probably) remove the "zs_" prefix on the table "zs_products_attributes" in the SQL statement. If you know how to view your SQL tables, view them and look for the correct table name. My tables do not have a "zs_" prefix, but your tables may have another prefix.
Change the line:
<code>$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE ("; </code>
<code>$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM products_attributes pa WHERE ("; </code>
OR change it to the product_attribute table name in your system.
Hope it works and you understand what I'm talking about...
Such a simple thing to miss.
And for people who installed Zen using fantastico.. you may have to change the table prefix to 'zen_' as fantastico can add it automaticly to your tables.
To find out what the table prefix is.. open cpanel
scroll down to phpMyAdmin and click it.
Find the database your zencart is using.
you will see at the start of each table a prefex ie: 'zen_'
copy the prefix and change the prefix in the header_php.php supplied with this addon
Find this line
and change zs_products_attributes to zen_products_attributes (or what ever your database prefix is)
$where_str .= " AND ((pa.products_id In (SELECT pa.products_id FROM zs_products_attributes pa WHERE (";
Hope this is of some help....