Find Jobs
Hire Freelancers

168644 Help with SQL

N/A

Selesai
Disiarkan lebih dari 16 tahun yang lalu

N/A

Dibayar semasa penghantaran
I have a problem with SQL used on my site: details below I have a table where users ratings are stored called RATING On my site I have the following sql statement which works fine for getting the records and displaying them however they are not in the correct rated order. SELECT * , SUM(rating_value) AS ave FROM rating_values, retailers_rating, retailers, retailers_categories WHERE retailers.publish_date<='2007-09-27' and (retailers.ending_date>='2007-09-27' or retailers.ending_date='0000-00-00') and retailers.available='1' and rating_values.rating_value_id=retailers_rating.rating_value_id and retailers.ret_cat_id = '19' AND retailers_categories.ret_cat_id='19' and retailers.retailer_id = retailers_rating.ret_id GROUP BY retailer_id ORDER BY ave DESC LIMIT 0, 10 I know how to solve the problem just not enough knowledge of SQL to implement it. where $NUMBER_OF_RATINGS appears in the SQL statement below is where the total number of records against each product stored in ratings table needs to appear eg 'SELECT * , SUM(rating_value/2) AS ave FROM ....' SELECT * , SUM(rating_value/$NUMBER_OF_RATINGS ) AS ave FROM rating_values, retailers_rating, retailers, retailers_categories WHERE retailers.publish_date<='2007-09-27' and (retailers.ending_date>='2007-09-27' or retailers.ending_date='0000-00-00') and retailers.available='1' and rating_values.rating_value_id=retailers_rating.rating_value_id and retailers.ret_cat_id = '19' AND retailers_categories.ret_cat_id='19' and retailers.retailer_id = retailers_rating.ret_id GROUP BY retailer_id ORDER BY ave DESC LIMIT 0, 10 the code i use to get the ratings is:- SELECT COUNT(*) as "NumberRatings" FROM `rating` WHERE `rating_value_id`>=1 group by `p_id` DESC
ID Projek: 1914840

Tentang projek

1 cadangan
Projek jarak jauh
Aktif 12 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hello, ready to help you. Please check PMB.
$25 USD dalam 0 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED KINGDOM
Waterlooville, United Kingdom
4.8
29
Ahli sejak Mac 16, 2011

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.