Birthdays and General Gifts
Notice: A non well formed numeric value encountered in /home/silkbou3/public_html/include/functions.php on line 825
Sat, 4th Feb 2012 08:43 am
(Opening Hours: 9am to 6pm Monday to Friday)
Birthdays, Anniversary's and General Gifts
Hand-crafted silk flower arrangements for all occasions.
Order online or by telephone. We are always happy to make gifts to your specifc criteria - please use the Contact Us form at the top or simply call us to dicsuss what you would like.
Designs can also be scented for that extra touch of reality. We can also make designs to your specification
SELECT * FROM sb_category_master WHERE is_active='Y' AND parent_id= 'C5190015657' order by category_orderTable 'silkbou3_silkbouquets.sb_category_master' doesn't existSELECT * FROM sb_product_master WHERE is_active='Y' AND is_ebook='N' AND category_ref_id = 'C5190015657' AND product_size_type = 'S' AND 1=1 ORDER BY added_on DESCTable 'silkbou3_silkbouquets.sb_product_master' doesn't existSELECT * FROM sb_product_master WHERE is_active='Y' AND is_ebook='N' AND category_ref_id = 'C5190015657' AND product_size_type = 'S' AND 1=1 ORDER BY added_on DESC LIMIT 0, 12Table 'silkbou3_silkbouquets.sb_product_master' doesn't exist
Your Recent History (Recently Viewed Products)
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

Birthdays and General Gifts


