Changing the ORDER BY in the prices module

Discussion in 'Mike-N-Tosh' started by vcallaway, Nov 16, 2009.

  1. vcallaway Customer

    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.
  2. Eric Barnes Guest

    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.

Share This Page