Skip navigation
matthew stuart
matthew stuart
Currently Being Moderated

Manual sorting of search results

Jun 21, 2012 7:44 AM

Tags: #php #database #mysql #sort_order #search_results #order_by

Is there a way to sort results manually without having to build stupidly complex arrays?

 

I need to sort initially in a very specific way like so:

 

Beer

Orange Juice

 

(then by A-Z)

 

Apple Juice

Brandy

Carrott Juice

Blah blah blah through to Z

 

Is it possible to do this even if I have to add the products in order manually?

 

I'm using PHP and MySQL.

 

Thank you.

346 Views   3 Replies   Latest reply: bregent, Jun 21, 2012 2:23 PM
 
Replies
  • matthew stuart
    Currently Being Moderated
    1. matthew stuart,
    Jun 21, 2012 9:12 AM   in reply to matthew stuart
    Report

    OK, so just to let you know that I am getting something, but it's by no means right, but messing with the code does seem to alter the sort order:

     

    ORDER BY DrinkType = 'Beer', DrinkType = 'Orange Juice', DrinkType = 'Apple Juice', DrinkType = 'Brandy', DrinkType = 'Carrot Juice', etc...

     

    However, by presenting it in this manner, the results print backwards like so:

     

    etc

    Carrot Juice

    Brandy

    Apple Juice

    Orange Juice

    Beer

     

    This is all very well, and I could change the order of the ORDER BY to be backwards so that it prints properly, but this isn't flexible and doesn't allow for new entries. Any new drink type NOT included prints before the specified sort order.

     

    Does anybody have any thoughts on this?

     

    Thanks.

     
    |
    Mark as:
  • DVita
    Currently Being Moderated
    2. DVita,
    Jun 21, 2012 10:17 AM   in reply to matthew stuart
    Report

    I came across this extension of Tom Muck

    http://www.tom-muck.com/extensions/help/SortRepeatRegion/

     

    I never used it myself.

    I used other extensions of Tom Muck an they were OK.

     

    Best Regards,

     
    |
    Mark as:
  • bregent
    Currently Being Moderated
    3. bregent,
    Jun 21, 2012 2:23 PM   in reply to matthew stuart
    Report

    How about creating a new column called 'sortfield'.  Assign 'aaa' to Beer and 'aab' to Orange Juice. For the rest of the items populate it with the same value as DrinkType. You could create a trigger to do that for you. Then just sort on the sortfield.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points