Not sure what is wrong

[Attila]

I am using a form so the user can search the database.  everything is working except the order at which items are searched.  I beleive it could be my coding but I am not seing a problem.

$sql = "SELECT * FROM ddoitems WHERE ItemDescription LIKE '%$item%' OR ItemName LIKE '%$item%' OR ItemType LIKE '%$item%' OR QuestName LiKE '%$item%' ORDER BY '%$Advance%' ASC";

The part that is not working ins the $Advance ASC it is not ordering things.  I know that $Advance is getting the information corectly to sort it because I have an echo statement to echo the value.

[dezkit]

$sql = "SELECT * FROM ddoitems

        WHERE ItemDescription LIKE '%$item%'

          OR

        ItemName LIKE '%$item%'

          OR

        ItemType LIKE '%$item%'

          OR

        QuestName LIKE '%$item%'

            ORDER BY '%$Advance%' ASC";

[Attila]

Thanks for the imput on the formating but I coppied exactly what you had and it is the same no help.  Any other ideas?

[dezkit]

can you tell me what is $advance?

[Attila]

Best to see it in action the formating isn't done but you will understand.  http://thaczero.com/test.php  The $advance is what you select on the radio buttons.

[dezkit]

and you want the order to be alphabetically?

 

[Attila]

Yes