Pulling all items by the id_product...
That is the mySQL for the recordset that I'm currently using. I have bottom navigation that I already have setup to pull the id of both the category and collections table to return the items with the foreign keys to match. What I was asking was how to use this recordset to return "all" items in the products table in DESC order by the id_product regardless of what collection or category they are from. A way for the user to select the products link from the main navigation which would then return all items to the products page allowing them to look through the entire catalog. Sorry about not being clearer in my initial post.