For 35$CAD fix the bugs on sorting companies (please read details below in the description)

Tamamlanmış İlan edilme: 5 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

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

Mühendislik MySQL PHP SQL Web Sitesi Testi

Proje NO: #18068735

Proje hakkında

1 teklif Uzak proje Aktif 5 yıl önce

Seçilen:

rajenranpara

Hello sir, I am a computer engineer. I am working with software development and debugging. I read the project description. I have worked with few php websites and for development and debugging. I also have wor Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% CAD
(16 Değerlendirme)
4.0