I'm using PHP to paginate the data, but I am trying to figure how I can group the data by price, name, etc. I know I will need to use an array of some sort
SELECT PRODUCTS.name,p_id,sku, image, description, model, CATEGORIES.category
id
WHERE PRODUCTS.name LIKE '%$title%'
ORDER BY p_id ASC $pages->limit";
Any suggestions?
Thanks
No need for an array of some sort, use the same ORDER BY like this:
ORDER BY p_id, PRODUCTS.name, CATEGORIES.category, models ASC $pages->limit
UPDATE
Lets say you have a select that posts the order by, something like:
<select name="order">
<option value="price">price</option>
<option value="name">name</option>
</select>
Then you clean the post and put it in the query like
$order = mysql_real_escape_string($_POST["order"]);
//and then
SELECT * FROM table ORDER BY $order;
