Support Forums

Changing the ORDER BY in the prices module

This is a discussion on Changing the ORDER BY in the prices module within the Mike-N-Tosh forums, part of the Third Party Support category; I would like to change the query in the prices module. Right now it has order by pTitle ASC. I ...


Go Back   68 Classifieds Forums > Third Party Support > Mike-N-Tosh

Reply
 
Thread Tools Display Modes
Old 11-16-2009, 11:43 AM   #1
Junior Member
 
Join Date: Nov 2009
Posts: 6
Rep Power: 0
vcallaway is on a distinguished road
Default Changing the ORDER BY in the prices module

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.
vcallaway is offline   Reply With Quote
Old 11-16-2009, 12:14 PM   #2
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 135
Eric Barnes is just really nice Eric Barnes is just really nice
Default

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.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline   Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prices Mike-N-Tosh Modification Release 0 01-13-2009 11:50 AM
Package Prices module Mike-N-Tosh Modules / Plugins / Modifications 4 04-20-2008 07:59 PM
nice sticky item...gas prices for usa... garysmith Off Topic 16 05-12-2006 04:47 PM


All times are GMT -4. The time now is 02:10 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2011, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0