Order in Search Results

Results 1 to 2 of 2

Thread: Order in Search Results

  1. #1
    Martin Guest

    Default Order in Search Results

    After the script searched the results, I would like it to place them by decending order. And to place them in order, I would add a table named "Value" or "Number" or "Whatever" in the database for the script to recognize which result is more important than the other. For exemple, I would place 20 to the most important results and 0 to the less important. But the values aren't just 20 and 0. It could be 4.45 - 12.67 or whatever. I just want the search script to show the biggest values first(most important listings) and the lowest values(the less important results)... Hope the explaination is good enough! Thanks a lot!

  2. #2
    Join Date
    Dec 1969

    Default Order By

    That is easy.<BR>select * from table_name order by order_field DESC<BR><BR>If you want ascending order, remove DESC

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts