Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Search Results Order

Quote Reply
Search Results Order
Okay... Ive seen many threads on this topic. But some how its not working for me. Maybe someone can help out.

Every link ID has been marked say "Type1" Type2" Type3" "Type4".

Thats because say Type1 are people, type2 are pics, type3 videos, and so on.

On my search results its getting all mixed up since its alpha.

I know where to change it and what to change, Im just not getting it working just right. Could it be something like this?:

Type2 DESC, Type4 DESC, Type1 DESC, Type3 DESC, Title (Title would be just in case? although ALL links have a typeX tagged to it so title wouldnt be needed.....).

Thanks everyone.

Juan Carlos
Quote Reply
Re: [Gorospe] Search Results Order In reply to
When you have multiple columns in an ORDER BY, it will use the next column when two rows have the same value for the first column (eg. two rows have Type2 = 1). If you used the specified ORDER BY, then it should have Type2 links first, then Type4, then Type1, and Type3. In each of those groupings, they will be ordered by the Title of the link.

Adrian
Quote Reply
Re: [brewt] Search Results Order In reply to
All IDs have only 1 type attached to them. So if I understand correctly, it should work, right? What would be the correct syntax? Pretty please.
Quote Reply
Re: [Gorospe] Search Results Order In reply to
What you have there should work.

Adrian