Sıralama mysql sorgu bitti sonra sonuç kümesi nasıl

0 Cevap php

Ben MySQL veritabanı 2 parametrelere sahip bir sorgu yazıyorum.

Its a basic search but the problem is I want to sort the order of the results on the basis of the selection. So after I've clicked the search button and the browser displayied the result set I want to order this specific result set by expiration-date or by price depending wich button i click.

   //SELECTION DATA FORM 
   <form action="EVENTS_SELECTION.PHP">
     <select name="Type">
     <option value="">SPORT
     <option value="">CULTURE       
     <option value="">LEISURE
     <option value="">GASTRONOMY
     </select>  

     <select name="WHERE">
     <option>ROME ALL
     <option>ROME SOUTH
     <option>ROME WEST
     <option>ROME EAST
     <option>ROME NORTH
     </select>

     <input type="submit" value="search">   
 </form> 

how can I achieve that?? thanks Luca

0 Cevap