$40 To Solve My Search Problem

Discussion in 'Design Contests' started by AquaMaureen, Oct 19, 2007.

  1. #1
    I have a php/mysql search of product inventory.

    All of the products are stored in the database as records. Each record (product) has several characteristics(columns). You are only able to search the records by 4 of the columns. This works fine.

    The problem I am having is with the sorting of the results. One of the columns follows no logical alpha/numeric sorting but there is a definite way it should be sorted.

    For searching this column, I have made another column with a number variable 1-9 representing highest to lowest and used the search label to represent the correct variable. The results that are displayed, though correct, are the actual variable and I can not get it to sort lowest to highest.

    I apologize, I am not a coder, and I know I am not describing this well.

    To win the contest, your solution must not drastically change the system i am using. It may be bass ackwards, but it works for us and we can update it with ease.

    Please PM me for details. I really appreciate everyone who participates.

    Payment is by paypal only.

    Thank you!
     
    AquaMaureen, Oct 19, 2007 IP