Printable View
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
First of all, I'd add a company id column to the companies table, and use that id as the foreign key in the offers table.
About your question, you can sort on multiple fields, but of course it will sort on one field, and then within each value of that first field, it will sort on the second field, ecc.
So what exactly do you mean when you say "to sort min price and max speed"? Can you give a data example?
i have list of companies , and i want to sort companies who have cheapest price , and highest speed and so on
Sorry, I didn't understand your query...
company_name type x 3g y wimax
id company_name offer_name speed cap_limit price offer_date 1 x xx1 6M 100GB 10.00 date 2 x xx2 5M 90GB 9.00 date 3 x xx3 5M 80GB 8.00 date 3 y yy1 6M 90GB 11.00 date
if i want to sort by minimum price then hieghest speed for each company
it will be:
3 x xx3 8.00 5M 90GB
2 x xx2 9.00 5M 80GB
...
It looks like all you need is an ORDER BY clause. Please take a look at the manual: http://dev.mysql.com/doc/refman/5.5/en/select.html
can i say .. order by price ASC , speed Desc ..... ?
yes, you can say thatQuote:
Originally Posted by mnask79
but i think you oughta test it first, so you know how it works