2. PHPRunner General questions
  3. Search and sort
This topic is locked

Search and sort

 		11/7/2007 08:01:31
PHPRunner General questions
O
 osluk author

I now have most of my application finished.
Is it possible to sort an advanced search.
Or does the advanced search need to be retuned first then sorted.
It the last example it seems the sort is ignored when an advanced search criterion is used.
Here is what I know
Search for wines with "Investors Choice" tickbox checked
Run search for "Investors Choice" returns Wines found: 9

http://bordeauxreport.com/db-2007/view/Wine_Data_list.php?a=search&value=1&SearchFor=1&SearchOption=Equals&SearchField=Collectable


Same search but also sorted by score high to low
Run search and add sort

http://bordeauxreport.com/db-2007/view/Wine_Data_list.php?a=search&value=1&SearchFor=1&SearchOption=Equals&SearchField=Collectable&?orderby=dIn+bottle+score+1


So we will next need to do the following wines from appelation Margaux with in bottle score present
Appleation Margaux 48 wines

http://www.bordeauxreport.com/db-2007/view/Wine_Data_list.php?a=search&value=1&SearchFor=Margaux&SearchOption=Equals&SearchField=Appellation


Margaux and score 43 wines

http://bordeauxreport.com/db-2007/view/Wine_Data_list.php?a=advsearch&type=and&asearchfield%5B%5D=Appellation&asearchopt_Appellation=Equals&value_Appellation=Margaux&value1_Appellation=&asearchfield%5B%5D=In+bottle&asearchopt_In_bottle=Contains&value_In_bottle=1&value1_In_bottle=]


Appelation Margaux AND priced between 325 - 980 GBP case

http://bordeauxreport.com/db-2007/view/Wine_Data_list.php?a=advsearch&type=and&asearchfield%5B%5D=Appellation&asearchopt_Appellation=Contains&value_Appellation=margaux&value1_Appellation=&asearchfield%5B%5D=Price+Oct+2007GBP&asearchopt_Price_Oct_2007GBP=Between&value_Price_Oct_2007GBP=325&value1_Price_Oct_2007GBP=980


Appleation Margaux current price 325 - 980 GBP sorted by % change since release

http://bordeauxreport.com/db-2007/view/Wine_Data_list.php?a=advsearch&type=and&asearchfield%5B%5D=Appellation&asearchopt_Appellation=Contains&value_Appellation=margaux&value1_Appellation=&asearchfield%5B%5D=Price+Oct+2007GBP&asearchopt_Price_Oct_2007GBP=Between&value_Price_Oct_2007GBP=325&value1_Price_Oct_2007GBP=980&?orderby=d07%5Fchange%5Frelease


Cheers Chris