Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Feb 2011
    Posts
    2
    Member #
    26942
    Hey all, very new here, search isn't working for me. looking for advice!

    I have a sales site, and I want to be able to put my top 3 most sold items on the home page. I believe i would need to match my links up against a counter or some sort....but I'm not sure from there. any advice?

  2.  

  3. #2
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,483
    Member #
    425
    Liked
    2783 times
    Code:
    Select Top 3 Product_Name from Products inner join Products_Orders on Products.Product_ID = Products_Orders.Product_ID where Sold = 1 order by Sum (Products_Orders.Quantity) DESC
    Modify the query according to your database.
    S0VERE1GN likes this.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)

  4. #3
    Junior Member
    Join Date
    Feb 2011
    Posts
    2
    Member #
    26942
    Quote Originally Posted by TheGAME1264, post: 198792
    Code:
    Select Top 3 Product_Name from Products inner join Products_Orders on Products.Product_ID = Products_Orders.Product_ID where Sold = 1 order by Sum (Products_Orders.Quantity) DESC
    Modify the query according to your database.
    This might be the best forum ever. thanks for the help.

  5. #4
    Senior Member LeenkzMike's Avatar
    Join Date
    Jan 2011
    Location
    Toe-Peek-ah, Kansas
    Posts
    608
    Member #
    26365
    Liked
    80 times
    Yeah! what GAME said!!!
    Peace, Mike
    WebHost1-For all your Hosting needs.
    Leenkz.Com-The web starts here! (Blatant use of tables)
    I realllllly need to feel useful, please "like" my signatures!!!! (Button is on the bottom right!)

  6. #5
    Unpaid WDF Intern TheGAME1264's Avatar
    Join Date
    Dec 2002
    Location
    Not from USA
    Posts
    14,483
    Member #
    425
    Liked
    2783 times
    Yeah, what TheGAME said!

    No probs, man.
    If I've helped you out in any way, please pay it forward. My wife and I are walking for Autism Speaks. Please donate, and thanks.

    If someone helped you out, be sure to "Like" their post and/or help them in kind. The "Like" link is on the bottom right of each post, beside the "Share" link.

    My stuff (well, some of it): My bowling alley site | Canadian Postal Code Info (beta)


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 06:14 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com