<% id=request.querystring("pductnum") if id="" then response.write(" No Data !!") else set aspthai=server.createobject("adodb.recordset") sql="Select * from products where id="&id aspthai.open sql,conn,1,3 set aspthai3=server.createobject("adodb.recordset") sql3="Select * from setting" aspthai3.open sql3,conn,1,3 %> " width=300 border=0> "> "> "> <%=aspthai("goodsname")%> Product ID: <%=aspthai("goodsid")%> <% if aspthai("goodsweight") > 1 then %> Weight: <%=aspthai("goodsweight")%> g <% end if %> <%=replace(aspthai("details"),chr(13)," ")%> <%dollarprice=aspthai("price")/aspthai3("dollar")%> Price: <%=aspthai("price")%> Baht (~US$<%=formatnumber(dollarprice,0)%>) US$1 = <%=aspthai3("dollar")%> Baht <%end if%>