<%@ LANGUAGE = "VBScript" %> <% 'Option Explicit %> <% productid=valid_sql(request.querystring("productid")) if productid=null or productid="" or not(isnumeric(productid)) then response.redirect("error.asp?msg=" & Server.URLEncode("We have no record of the product you are looking for.")) end if 'get the relevant products details set rsprod=db.execute("SELECT * FROM products INNER JOIN categories ON products.catcode = categories.catcode WHERE productid = " & productid) if rsprod.eof then response.redirect("error.asp?msg=" & Server.URLEncode("We have no record of the product you are looking for.")) end if 'get names and codes of all products in that category set rscatlist=db.execute("select name,productid from products where catcode=" & rsprod("catcode") & " order by name") %> <% header categorymenu %>

Search Categories Calculator Chinese Zodiac Photo Frames Ionizer ( Air Purifier ) KitchenWare Mini Shoes - Jewel Watches Promotions Seafood Restaurants Make us your Homepage Add us to your Favorites List your Website Tell a Friend about Us   Useful Links Overseas Yellow Pages Business Guide Singapore Aquarium Maids Agency   Payment Options      Cash on Delivery Demand Draft Cheque   <% if stage="" or stage=null then %> <% else %> <% end if %> " border="0"> <%= rsprod("name") %> <%= rsprod("description1") %> <%= rsprod("description2") %> Price: <%= cursymbol & formatnumber(rsprod("price")) %>   How many of these do you want to order? Quantity:

For any information and queries please mail to: Webmaster For bulk orders e-mail at shopping@singaporeshoppingmall.com

About Us     |     Privacy policy     |     Disclaimer     |     Affiliates     |     Contact Us Shipping policy     |     Terms & conditions     |     FAQ's     |     Customer service     |     Testimonials

Copyright 2003. Singapore Business Guide. All right reserved.

<% db.close set db=nothing %>