//BOF Product Color Option public function getProductColorOptions($product_id) { $product_color_options = array(); $product_option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_option po LEFT JOIN `" . DB_PREFIX . "option` o ON (po.option_id = o.option_id) LEFT JOIN " . DB_PREFIX . "option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '" . (int)$product_id . "' AND od.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY o.sort_order"); foreach ($product_option_query->rows as $product_option) { if ($product_option['type'] == 'color') { $product_option_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '" . (int)$product_id . "' AND pov.product_option_id = '" . (int)$product_option['product_option_id'] . "' AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY ov.sort_order"); foreach ($product_option_value_query->rows as $product_option_value) { $product_color_options[] = array( 'color_name' => $product_option_value['name'], 'color_code' => $product_option_value['color_code'] ); } return $product_color_options; } } return $product_color_options; } //EOF Product Color Option Odile- Mycra Pac, Lauren Vidal, Lisette, Anu Ligne Clothing, Rain Gear, Raincoats,
alashan mycra pac 1 anue ligne mycra pac2 jewelry
 Odile of New York City is an eclectic website offering you the latest fashion trends along with timeless classics. 
Odile's first boutique near Florida's famed Safety Harbor Spa enabled her to meet Spa guests from all over the world and even after their departure her clients continued to keep in touch with her knowing that she would always find the latest trends. Her loyal customers could not find unique clothing in their home town and encouraged her to expand her website when she returned to New YorK City.
Back living in New York City, Odile has never been happier or busier as she travels the world, attends fashion shows, color forecast seminars and European trade shows.
Odile is continually finding new fashion trends to share with you and she will continue to offer you the latest and best fashion trends on Odile of New York City's new website. Lisette L, Lauren Vidal and Mycra Pac raincoats are Odile's best sellers.

Odile- Mycra Pac, Lauren Vidal, Lisette, Anu Ligne Clothing, Rain Gear, Raincoats,


Copyright 2014 Odile of New York- 155 East 38th Street New York, NY 10016 Suite 20 G
Call 646-649-4434
Site Design by: Zucker and Zucker
Odile sells Mycra Pac travel and rain wear, Lauren Vidal of Paris clothing and pants and designer jewelry. Licensed retailer for Mycra Pac, Lisette Pants and Lauren Vidal Clothing.