Gift Features in SB
Notice: A non well formed numeric value encountered in /home/silkbou3/public_html/include/functions.php on line 825
Fri, 10th Feb 2012 04:48 am
(Opening Hours: 9am to 6pm Monday to Friday)
Silkbouquets has launched a special feature for gift wrapping. When you place your order, you can select the gift tag and write your own message.
On request we can make special gift wrapping arrangements, please contact us to discuss what you would like.
Why not buy a display for a birthday as a home decoration
Tulip Bridal Posies
£34.50
Free Book - How to Plan a Wedding
Free Wedding Planner Guide! Limited to only 100 being given away FREE on all orders from any item in the Wedding Section over £35
Read More
Free Wedding Planner Guide! Limited to only 100 being given away FREE on all orders from any item in the Wedding Section over £35Read More
We accept payment by
Debit Cards, Switch, Maestro, MasterCard & Visa No surcharges on any cards We accept BACS, Wire Transfer, cheque or cash

Debit Cards, Switch, Maestro, MasterCard & Visa No surcharges on any cards We accept BACS, Wire Transfer, cheque or cash

SELECT
p.product_id,p.product_name,p.product_page_name,p.product_discount,
s.product_price,s.product_weight,s.size_ref_id,
sz.size_title,
c1.category_title as pTitle,
c2.category_title as cTitle,
i.image_name,i.image_alt,
i.color_ref_id
FROM
sb_product_master as p
LEFT JOIN sb_price_master as s ON s.product_ref_id = p.product_id
LEFT JOIN sb_category_master c1 ON c1.category_id = p.category_ref_id
LEFT JOIN sb_category_master c2 ON c2.category_id = p.subcat_ref_id
LEFT JOIN sb_image_master i ON i.product_ref_id = p.product_id
LEFT JOIN sb_color_master c ON i.color_ref_id = c.color_id
LEFT JOIN sb_size_master sz ON sz.size_id = s.size_ref_id
WHERE
p.is_active = 'Y' AND p.is_footer = 'Y' and is_ebook = 'N'
GROUP BY
p.product_id
ORDER BY
p.added_on DESC Table 'silkbou3_silkbouquets.sb_product_master' doesn't exist

Gift Features in SB


