按列表生成排序

I have a data like this :

   car_id | price_id | transmission_id | group_id | image_id
   =======|==========|=================|==========|=============
 1. CAR A | $20/hour | Automatic       | GROUP A  | image_1.jpg
 2. CAR B | $30/hour | Automatic       | GROUP B  | image_2.jpg
 3. CAR C | $40/hour | Manual          | GROUP C  | image_3.jpg
 4. CAR D | $20/hour | Manual          | GROUP A  | image_4.jpg
 5. CAR E | $30/hour | Manual          | GROUP B  | image_5.jpg
 6. CAR F | $40/hour | Automatic       | GROUP D  | image_6.jpg

So, the lists can be selected (choose) by "group_id" or "transmission_id". User can tick and automatically generate result sort by :

  • Group A,B,C,D
  • Transmission Automatic,Manual
  • Group + Transmission

The result shown on the same page. Is it possible if I don't want to use MySQL?