I have two MySQL tables, one with categories and one with products. For the first one, I also have a column which describes the category order. What I want to do is get all the products and sort them by category (which needs to be sorted ascending according to the 'order' field) and by price (also ascending). The tables are:\[code\]categories-id, (int)- name, (text)- order (int) products- id, (int)- model, (text)- price, (float)- category_id (int)\[/code\]
Problem with sorting results over two different columns
- Thread starter ghofranho
- Start date