I have a site (www.chiquis.com). when I click on a tab at the top, I come to "cat.asp" which shows all products in one category.

Now I need a cat_all.asp which shows ALL products. I haven't worked with ASP and SQL so I don't want to go in and change the code. but basically I want to change from:

SELECT * FROM products WHERE type="skirts" ORDER BY id DESC

to

SELECT * FROM products WHERE type="skirts" ORDER BY id DESC

I have attached the file so that you can check the full queries.

2. I also have a request. The page shall show all queries, with the last added product, listed first. But perhaps I want to alter this so that a specific product is not the first one. Better than using id could be using some field which we can alter when needed.

/Peder