Gossamer Forum
Home : Products : DBMan : Customization :

Sorting question

Quote Reply
Sorting question
Hi. Looked around but may have missed it. Has anyone figured out how to do a sort, have the records displayed that meet the sort criteria AND then display the remaining records in the database. I would like to have certain records always displayed at the top, before the rest. Make any sense?

If this makes any sense, would this work? Call the script with the first sorting parameters, then insert code so that the script runs again with the other sorting parameters. The sorting parameters will always be the same for both searches.

Thanks

Last edited by:

spike: Nov 13, 2003, 4:58 PM
Quote Reply
Re: [spike] Sorting question In reply to
You could add another field to your database called lets say "topsort" and then the records you want displayed at the top would need to be given a value of 1 in that field and records not included would be just left blank in that field, and then you just sort the results by that field, you could even give the top records a ranking within their own sort by increasing that value for some.



chmod