For 35$CAD fix the bugs on sorting companies (please read details below in the description)
$10-30 CAD
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
Proje NO: #18068735
Proje hakkında
Seçilen:
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