Codezwiz >> Forums >> General PHP Nuke Help >> Sort sql query results twice using different values?

This may or may not be possible, I haven't seen anything relevant looking through php.net for a solution, maybe I have seen the answer and just not noticed it.

I want to query and sort by 'something numerical' asc and then sort again alphabetically within the numerical sorting. For instance. Two rows where one's $lev is 2 and the other is 1. So they are sorted 1 first then 2. Then sort again alphabetically so when I list them in the loop it'll print the 1 first and it's $var aplphabetically as well. I hope this makes sense

Its that word "within" thats kicking my butt. Not that it is not possible, but I have no quick solution for you. The only way I could think of is to print it twice and you obviously don't want that.

I would think they have to relate to each other in some way. I understand what you want, I just can't figure out why.

<--picks up his imaginary phone to call telli.

Let me give you a direct example. there is a table named nuke_feats. in its structure there is a flevel (which is numbers only)row and a fname (which is aplhabetical names) row. on the output page I'm seperating each into 2 colums per result. But, I want to seperate the Numbers (IE: Seperate all the #1's then the #2's so on and so forth) And in the #1's sort them Aphabetically.

I just had an idea, which is what I should have tried before asking, in my query change the where flevel is 1 and then sort by name asc. Then for the next section where flevel is 2 so on and so forth. Sheesh. I should have thought of that sooner.

Ah, I see what your saying. I have never tried a treat like this. So let me know where your fresh idea leads you. I personally do best when I can look at the code. You might wanna attach a snipplet of the code in zip.