Well after a lot of hard work, I managed to make a plugin which pulled any profile field I selected.
Currently, it is fetching data from two tables:
user and
userfield
Here is the result
Currently I am sorting these data based only from a single field in my query.
Code:
ORDER by userfield.field26 DESC
Here's my question:
What I would like to know, is if there is an easier way to make the titles of these columns clickable (highlighted in red in pic), so when you click the titles (Graduation Year, Height, Weight) the system will sort those columns in accordance with that respective field
The picture will explain it better.
I appreciate your time and looking forward to replies.
Val.