I would like to change the query in the prices module. Right now it has order by pTitle ASC. I would prefer it used the same sort as the system does. The administration module has a field for display order, problem is I don't know the field name in the table. What should the query be changed to? Thanks.
The system uses: Code: ORDER BY pOrder ASC So you may want to change yours to: Code: ORDER BY pOrder ASC, pTitle ASC That way you are covered both ways.