<%
set Prs = Server.CreateObject("ADODB.Recordset")
Prs.CursorLocation = 3 ' adUseClient
If Request.QueryString("Bid") = 1 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=1 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 2 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=2 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 3 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=3 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 4 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=4 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 5 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=5 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 6 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=6 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 7 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=7 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 8 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=8 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 9 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=9 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 10 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=10 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 11 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=11 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 12 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Brand_Id=12 AND p.Category_Id=1 Order By Product_Id ASC", cn
elseIf Request.QueryString("Bid") = 0 then
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Category_Id=1 Order By Product_Id ASC", cn
mark = "all"
else
Prs.Open "SELECT Product_Id, Brand_Image, Product_Image, Product_Name, Product_Model, Product_Description, Product_Price, Product_Qty, Product_Warranty, Product_Disable, Product_Condition FROM Products as p, Brand as b WHERE p.Brand_Id=b.Brand_Id AND p.Category_Id=1 Order By Product_Id ASC", cn
mark = "all"
End if
if Prs.bof = false and Prs.eof = false then
%>
<% if mark="all" then %>        
<% else %> %>) <% end if %> |
|
| Product |
Description |
Price |
Cond. |
Warranty |
|
|
