Line 37: strSelect = "SELECT s.id, s.title, CONCAT(LEFT(s.description, 255), '...') AS description, price, ss.title AS size FROM stock s LEFT OUTER JOIN size_price_lookup spl ON spl.stock_id = s.id INNER JOIN stock_sizes ss ON ss.id = spl.size_id WHERE spl.id = (SELECT id FROM size_price_lookup WHERE price = (SELECT MIN(price) FROM size_price_lookup WHERE stock_id = s.id) AND stock_id = s.id LIMIT 1) AND s.id IN (SELECT stock_id FROM category_stock_lookup WHERE category_id = " + intCatID.ToString() + ") AND visible > 0 ORDER BY s.title";
Line 38:
Line 39: categoryTitle.InnerHtml = PMCategory.GetTitle(intCatID);
Line 40:
Line 41: lblCatDesc.InnerHtml = PMCategory.GetDescription(intCatID);
|