已关闭

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

for 35$cad

技能: 平面设计, HTML, PHP, 网站设计

查看更多: employee details project classic asp, scholarship project various companies student know javaoracle, java read file project, types of cad jobs, jobs that use cad skills, cad drafter, image processing noise reduction details project java, software project management companies malaysia, contact details phone addresses companies, project estimation companies hyderabad, free project textile companies vehicle system, excel macro read microsoft project, script program read details mp3, company employees details project, embedded memory stick details project, php excel read write project, project management companies name amman jordan, read script project, kindly send details project traducir, telemarketing project australian companies

关于此雇主:
( 19个评论 ) Trois-Rivières, Canada

项目ID: #18068645

1 威客就此工作平均出价 $20

kaleabmekonen

I am a software engineering student who love to code and I would love to help you in doing the task u are gonna assign to me. I love to challenge new stuff and I am curious on not only performing my task but making it 更多

$20 CAD 在5天内
(0条评论)
0.0