Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Sort by price

Feb 20, 2004, 8:21 AM
silane
New User (1 post)
Feb 20, 2004, 8:21 AM
Post #1 of 8
Views: 4692
Shortcut
Quote Reply
Sort by price
I have a column, price in as INT. How can I set Build Option such that it will list from low price to highest or the other way round?






Zetta mall
Feb 20, 2004, 8:54 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Feb 20, 2004, 8:54 AM
Post #2 of 8
Views: 4616
Shortcut
Quote Reply
Re: [silane] Sort by price In reply to
Setup > Build Options > build_category_sort_order (i think)...

Try adding this in front;

Code:
price DESC,

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
May 6, 2005, 1:01 PM
imp
Novice (16 posts)
May 6, 2005, 1:01 PM
Post #3 of 8
Views: 4568
Shortcut
Quote Reply
Re: [Andy] Sort by price In reply to
this didnt works....! if i do that....

in my linklist (in categorys)

the first is an

9,95
then
29,95
then
199,95
19,95
12.95

its because the first number !!!
May 7, 2005, 3:32 AM
el noe
User (434 posts)
May 7, 2005, 3:32 AM
Post #4 of 8
Views: 4533
Shortcut
Quote Reply
Re: [imp] Sort by price In reply to
Alex helped me with this one. Go to:
http://www.gossamer-threads.com/...orum.cgi?post=169214

If you change your table this way sorting within setup should not be a problem I guess.

Regards

n || i || k || o

Last edited by:

el noe: May 7, 2005, 3:34 AM
May 7, 2005, 3:43 AM
imp
Novice (16 posts)
May 7, 2005, 3:43 AM
Post #5 of 8
Views: 4533
Shortcut
Quote Reply
Re: [el noe] Sort by price In reply to
ok...id changed the table but how do i do a "resync" ???
May 7, 2005, 6:26 AM
Bigpat
User (52 posts)
May 7, 2005, 6:26 AM
Post #6 of 8
Views: 4561
Shortcut
Quote Reply
Re: [imp] Sort by price In reply to
Go to: Database -> Repair Tables
and Database -> Rebuild Search

_________________________________________________________________________________________________________________
Web directory and search engine | Dirlist.net Directory - Add your link today.

Last edited by:

Bigpat: May 7, 2005, 6:28 AM
May 7, 2005, 7:36 AM
el noe
User (434 posts)
May 7, 2005, 7:36 AM
Post #7 of 8
Views: 4502
Shortcut
Quote Reply
Re: [imp] Sort by price In reply to
go to database select links, properties and press go ... at the bottom of the main frame there is a resync database
May 7, 2005, 7:44 AM
imp
Novice (16 posts)
May 7, 2005, 7:44 AM
Post #8 of 8
Views: 4502
Shortcut
Quote Reply
Re: [el noe] Sort by price In reply to
thank you very mutch guys.......!!!!!!! it works .....!!!!