hi all ,

i have two tables , first one for companies , and second one for companies offers :

companies table design is :
company name company type

offers table
id company_name offer_name speed price cap_limit offer_date

how it will be the query to sort , min price and max speed , or max cap_limit and min price ...i want the user will sort offer depend on multi criteria

i hope u got me , thanks a lot guys