Shopping Bag

0 Items

Please add a product to your shopping bag in order to checkout.

Free US Standard Shipping Over $50!

Total $0.00

Excl. Shipping & Taxes
SELECT * FROM ecru_product_filter_category WHERE filter_id IN(SELECT product_filter_id FROM ecru_product_filter WHERE filter_link='style' AND filter_status=1) AND filter_category_status=1 ORDER BY filter_category_order ASC
Array ( [0] => Array ( [product_filter_category_id] => 10 [filter_id] => 2 [filter_category_name] => Texturize<br>and Groom [filter_category_link] => texturize-and-groom [filter_category_new] => 0 [filter_category_order] => 1 [products] => 51,52 [freq_used_products] => 54,8 [filter_category_status] => 1 ) [1] => Array ( [product_filter_category_id] => 11 [filter_id] => 2 [filter_category_name] => Subtle Body<br>and Sheen [filter_category_link] => subtle-body-and-sheen [filter_category_new] => 0 [filter_category_order] => 2 [products] => 16,8 [freq_used_products] => 53,10 [filter_category_status] => 1 ) [2] => Array ( [product_filter_category_id] => 12 [filter_id] => 2 [filter_category_name] => Curls Without Frizz [filter_category_link] => curls-without-frizz [filter_category_new] => 0 [filter_category_order] => 3 [products] => 45,44 [freq_used_products] => 16,53 [filter_category_status] => 1 ) [3] => Array ( [product_filter_category_id] => 13 [filter_id] => 2 [filter_category_name] => Smooth<br>and Silky [filter_category_link] => smooth-and-silky [filter_category_new] => 0 [filter_category_order] => 4 [products] => 3,16 [freq_used_products] => 10 [filter_category_status] => 1 ) [4] => Array ( [product_filter_category_id] => 14 [filter_id] => 2 [filter_category_name] => Maximum Volume [filter_category_link] => maximum-volume [filter_category_new] => 0 [filter_category_order] => 5 [products] => 7,54 [freq_used_products] => 11,52 [filter_category_status] => 1 ) [5] => Array ( [product_filter_category_id] => 15 [filter_id] => 2 [filter_category_name] => Creating Curls<br>that Last<br>(Hot Tool Use) [filter_category_link] => creating-curls-that-last-hot-tool-use [filter_category_new] => 0 [filter_category_order] => 6 [products] => 11 [freq_used_products] => 54,53 [filter_category_status] => 1 ) )