Sorting data by relevance, from multiple tables
- by Oden
Hey,
How is it possible to sort data from multiple tables by relevance?
My table structure is following:
I have 3 tables in my database, one table contains the name of solar systems, the second for e.g. of planets. There is one more table, witch is a connection between solar systems and planets.
If I want to get data of a planet, witch is in the Milky Way, i post this data to the server, and it gives me a multi-dimensional array witch contains:
The Milky Way, with every planet in it
Every planet, witch name contains the string Milky Way
(maybe thats a bat example because i don't think that theres but one planet with this name, but the main concept is on file)
But, i want to set the most relevant restaurants to the top of the array. (for the relevance i would check the description of the restaurants or something like that)
So, how would you do that kind of data sorting?