Array
(
[0] => Array
(
[top] => true
[path] => cPath=1
[current] =>
[name] => Candle Wax
[image] => categories/candle-wax.jpg
[has_sub_cat] => 1
)
[1] => Array
(
[top] => true
[path] => cPath=22
[current] =>
[name] => Candle Wicks
[image] =>
[has_sub_cat] =>
)
[2] => Array
(
[top] => true
[path] => cPath=2
[current] =>
[name] => Candle Dyes
[image] =>
[has_sub_cat] =>
)
[3] => Array
(
[top] => true
[path] => cPath=3
[current] => 1
[name] => Fragrance Oils
[image] =>
[has_sub_cat] => 1
)
[4] => Array
(
[top] => false
[path] => cPath=3_66
[current] =>
[name] => - - All Fragrances
[image] =>
[has_sub_cat] =>
)
[5] => Array
(
[top] => false
[path] => cPath=3_76
[current] =>
[name] => - - Fresh
[image] =>
[has_sub_cat] =>
)
[6] => Array
(
[top] => false
[path] => cPath=3_67
[current] =>
[name] => - - Christmas
[image] =>
[has_sub_cat] =>
)
[7] => Array
(
[top] => false
[path] => cPath=3_74
[current] =>
[name] => - - Citrus
[image] =>
[has_sub_cat] =>
)
[8] => Array
(
[top] => false
[path] => cPath=3_73
[current] =>
[name] => - - Designer
[image] =>
[has_sub_cat] =>
)
[9] => Array
(
[top] => false
[path] => cPath=3_69
[current] =>
[name] => - - Floral
[image] =>
[has_sub_cat] =>
)
[10] => Array
(
[top] => false
[path] => cPath=3_70
[current] =>
[name] => - - Fruit
[image] =>
[has_sub_cat] =>
)
[11] => Array
(
[top] => false
[path] => cPath=3_68
[current] =>
[name] => - - Herbal
[image] =>
[has_sub_cat] =>
)
[12] => Array
(
[top] => false
[path] => cPath=3_77
[current] =>
[name] => - - Sweet
[image] =>
[has_sub_cat] =>
)
[13] => Array
(
[top] => false
[path] => cPath=3_71
[current] => 1
[name] => - - Tropical
[image] =>
[has_sub_cat] =>
)
[14] => Array
(
[top] => false
[path] => cPath=3_75
[current] =>
[name] => - - Vanilla
[image] =>
[has_sub_cat] =>
)
[15] => Array
(
[top] => false
[path] => cPath=3_72
[current] =>
[name] => - - Wood
[image] =>
[has_sub_cat] =>
)
[16] => Array
(
[top] => true
[path] => cPath=78
[current] =>
[name] => Reed Diffusers
[image] =>
[has_sub_cat] =>
)
[17] => Array
(
[top] => true
[path] => cPath=82
[current] =>
[name] => Candle Containers
[image] =>
[has_sub_cat] => 1
)
[18] => Array
(
[top] => true
[path] => cPath=4
[current] =>
[name] => Candle Making Kits
[image] =>
[has_sub_cat] =>
)
[19] => Array
(
[top] => true
[path] => cPath=87
[current] =>
[name] => Candle Making Extras
[image] =>
[has_sub_cat] =>
)
)
Tropical Fragrance Oils
Tropical Fragrance Oils
£1.99 inc. VAT ( £1.66 exc. VAT )
£1.69 inc. VAT ( £1.41 exc. VAT )
£1.59 inc. VAT ( £1.33 exc. VAT )
£1.81 inc. VAT ( £1.51 exc. VAT )
£1.59 inc. VAT ( £1.33 exc. VAT )
£1.59 inc. VAT ( £1.33 exc. VAT )
£1.59 inc. VAT ( £1.33 exc. VAT )
£1.69 inc. VAT ( £1.41 exc. VAT )
£1.79 inc. VAT ( £1.49 exc. VAT )
Displaying 1 to 9 (of 9 products)
Array
(
[customers_host_address] => ec2-54-224-89-34.compute-1.amazonaws.com
[cartID] =>
[cart] => shoppingCart Object
(
[contents] => Array
(
)
[total] => 0
[weight] => 0
[content_type] =>
[free_shipping_item] => 0
[free_shipping_weight] => 0
[free_shipping_price] => 0
[download_count] => 0
[total_before_discounts] => 0
[display_debug_messages] =>
[flag_duplicate_msgs_set] =>
)
[language] => english
[languages_id] => 1
[languages_code] => en
[securityToken] => 5056752e61599321b4d7d8e18234a252
[check_valid] => true
[navigation] => navigationHistory Object
(
[path] => Array
(
[0] => Array
(
[page] => index
[mode] => SSL
[get] => Array
(
[cPath] => 3_71
)
[post] => Array
(
)
)
)
[snapshot] => Array
(
)
)
[currency] => GBP
[today_is] => 2018-10-19
[updateExpirations] => 1
[product_listing_max_display] => 24
[customers_ip_address] => 54.224.89.34
[payment] => paypalwpp
[listing_sql] => select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id
where p.products_status = 1
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = '71' order by p.products_sort_order, pd.products_name
)
