Line 16:
Line 17: var product = db.QuerySingle("SELECT * FROM Products WHERE ProdCode = @0", productcode);
Line 18: var categoryname = db.QueryValue("SELECT Title FROM Category WHERE ID =@0", product.category);
Line 19: var subcatof = "";
Line 20: var mightlike = db.Query("SELECT TOP 4 Title, Sale, ProdCode, Image1 FROM Products WHERE Live ='Yes' AND Category =@0 AND ID <> @1 ORDER BY NEWID()", product.category, product.id);
|