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?