The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
Sort by Field
Hello friends.
I am trying to sort the results of a MySQL query I am processing. Here is some background. I have a list of possible values for a column. This list has 3 values that are always possible, the rest of the values can changed. I want to sort by this column, but in a specific way. I know I can do Code:
ORDER BY FIELD(bla, 'val1', 'val2'), bla ASC ForeverValue1 ForeverValue2 Variables ASC .. .. ForeverValue3 (If you want to know why I want this its because I am generating a dynamic page but I want to use as few loops as possible. I could easily loop through these fields how I wanted in php but if I can sort them beforehand it will save me on code and pageload time.) |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|