Home
About Us
Golfing Gifts
Contest
Join Our E-Mail List
Golfing Links
Contact Us
Free Shipping
 
US Visitors
 
<% Set rs = server.CreateObject("ADODB.Recordset") strSQL = "select * from Subcategory where subcate_id=" & request("subcate_id") rs.open strSQL, dbCon If Not rs.EOF Then subcate_brand = rs("subcate_brand") subcate_name = rs("subcate_name") subcate_price = rs("subcate_price") subcate_sale_price = rs("subcate_sale_price") subcate_desc = rs("subcate_desc") subcate_notes = rs("subcate_notes") subcate_picPath = rs("subcate_picPath") category_id = rs("f_category_id") end if rs.close Set rs = server.CreateObject("ADODB.Recordset") strSQL = "select * from Category where category_id=" & category_id rs.open strSQL, dbCon If Not rs.EOF Then category_name = rs("category_name") end if rs.close dbCon.close %>
<%=subcate_brand%>
<%=subcate_brand & " " & subcate_name%>

<% if isnull(subcate_sale_price) or subcate_sale_price="" or subcate_sale_price="0" then%> Price: $<%=subcate_price%>
<% else %> Regular Price: $<%=subcate_price%>
Sale Price: $<%=subcate_sale_price%>
<% End If%>

<%=subcate_desc%>

<%=subcate_notes%>

 
To place an order by phone, we accept Visa, Mastercard and American Express. Our hours of operation are 8am to 8pm, 7 days a week. In stock orders are shipped within 24-48 hours.