Here is the problem: I want my data sorted in 2 differents way without calling two times the database.
Example:
SELECT data FROM costumers WHERE x ORDER BY budget, car, home
I need this data sorted in this way to do fast some operations.
In the meantime I need also the same data but:
ORDER BY home, budget, car
I can reorder the data in php or make a second query to my database but I hope there is a simplee and faster way to make it works with MySql. (maybe the data could be fetch in two differents ways)
Thanks in advance :)
(first time I post, but not first time this website helps me)
Aucun commentaire:
Enregistrer un commentaire