rating in website

Question

hi every oneI want design wesite that users can put their product in this sitethis is my users table in DB  IdUserscodeProductnameProduct imageProductpricecount                   i want put rating for my users product that when we search in website it show users information  that have more product how i can do itthanks

vinayak · Accepted Answer

sort by date mye be create proble try this select  top 10 furniturechidfurniturechnamefurniturechaddress  COUNTfurniturechname as count from furniturech inner join furniturep on furniturepbehcode  furniturechbehcode where furniturechfcode  1 and furniturepdate lt GETDATEgroup by furniturechidfurniturechnamefurniturechaddressorder by count

vinayak · Answer

use following query in your store procedureit gives you result what u want select  top 100 furniturechid furniturechnamefurniturechaddress  COUNTfurniturechname as count  from furniturech inner join furniturep on furniturepbehcode  furniturechbehcode  where furniturechfcode  FCode and furniturepdate lt GETDATE group by furniturechidfurniturechnamefurniturechaddress order by count desc

vinayak · Answer

use following query in your store procedure select  top 100 furniturechid  furniturechnamefurniturechaddress into furniture   from furniturech inner join furniturep on furniturepbehcode  furniturechbehcode   where furniturechfcode  FCode  order by furniturepdate descselect idnameaddress COUNTname as count from furnituregroup by Idnameaddressorder by countdrop table furniture

Id	Users_code	Product_name	Product _image	Product_price	count

rating in website

Company

Explore

Follow us

Contact Us