please read the details on my project for sorting companies for 35$CAD

User Avatar i can start right now ok can you check the files before ? to see if you are able. User Avatar yes, let me check plz the files are already provided below the description User Avatar yes i am checking ok thank you and please read the description on freelancer.com this is the workd to be done. on [login to view URL] on sorting on the first select down menu. on [login to view URL] and if you want to do the work I will provide you the ftp access let me know all access database too Yes ,, But I did not understand what to do User Avatar how to sort this database login to [login to view URL] first User Avatar ok let me with user: jonano and pass: lindadube Most popular would be the number of reviews ([login to view URL] Simple and [login to view URL] Plus combined) and Most Interested to Invest In, the number of rows with the value 1 in rate table according to the company, Less Interested to Invest In would be the opposite as well as Less Popular, there is another question Would you be interested to invest in ? on [login to view URL] Plus so we must take this in consideration too. do you see the first select down menu User Avatar yes i logged in it takes times to select User Avatar can we call no its ok User Avatar i am logged in , now what to do ? Best Noted is like Most Popular Most popular would be the number of reviews ([login to view URL] Simple and [login to view URL] Plus combined) and Most Interested to Invest In, the number of rows with the value 1 in rate table according to the company, Less Interested to Invest In would be the opposite as well as Less Popular, there is another question Would you be interested to invest in ? on [login to view URL] Plus so we must take this in consideration too. in rating table at the end "invest" with 1 the column User Avatar Best Noted is like Most Popular , Where it is? on/rating-portal if you check Sorting and select the first word "Select" User Avatar yes there are 3 sections to select Most Popular and Less Popular is not Worst Noted and Best Noted, this is the quantity of ratings/reviews the firs section User Avatar yes got it the first section User Avatar so what should i select now? the first section Most Popular and Less Popular is not working good it should sort with per # of reviews which is Valuater the # of ratings of [login to view URL] Simple + [login to view URL] Plus do you want to see the database ? yes let me see it User Avatar do you want me to write php script to sort these [login to view URL] user: jonano, pass: desps1112 click database and click jonano_aim table rate and table rating dont delete anything ok dont worry User Avatar let me check it ajax_super is the table of the companies User Avatar link is not opening which link ? it's a pop up User Avatar opened brb yes i opened the database ajax_super, i cant fint this table User Avatar r u there ? hi yes did you open jonano_aim yes i opened it ' yes got it ajax super User Avatar now what to do ? do you see table rate and table rating too ? User Avatar yes got that I want to calculate and sort companies by Most Popular or Less Popular with: the # of ratings of [login to view URL] Simple + [login to view URL] Plus User Avatar rate and rating , are there [login to view URL] simple is table rate [login to view URL] plus is table rating User Avatar How will i sort them by changing their values from data base? no you change nothing on the database just by selecting see [login to view URL] on ftp: [login to view URL] , user: jonano, pass: desps1112 JOIN or GROUP BY I dont know User Avatar give me 10 minutes, because right now Most Popular is like Best Noted which is the samething which it should not it should be by the number of reviews Most Popular = the number of reviews done to the company it's logic not ? ok fine but how do i sort them yes of course it should like this Most Popular = the number of reviews User Avatar agreed yes but I dont know how select them between 2 table if I check: form_id for rate form_id