Support Forums

vcallaway + · 11-16-2009, 11:43 AM

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.

Eric Barnes · 11-16-2009, 12:14 PM

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.

11-16-2009, 11:43 AM	#1
vcallaway + Junior Member Join Date: Nov 2009 Posts: 6 Rep Power: 0	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.

11-16-2009, 12:14 PM	#2
Eric Barnes 68 Classifieds Staff Join Date: Mar 2006 Location: Belmont, NC Posts: 5,489 Rep Power: 135	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

Support Forums

Changing the ORDER BY in the prices module