Orionsbelter Posted September 7, 2011 Share Posted September 7, 2011 OKs i have two tables. One contains a userID this is in table 'info' and the other contain a totalPrice in table 'payment' for an order. Both tables are linked by the ID field. I'm trying to find a way using PHP to look at the database and find the top 5 customers; this means i have to look into the database and find all orders add up total price of all users orders and find out whos spent the most money from thier order(s). Quote Link to comment Share on other sites More sharing options...
fenway Posted September 7, 2011 Share Posted September 7, 2011 Yup, you've got it -- join the tables, use SUM(payment), GROUP BY userID, and then order by the SUM(), DESC, LIMIT 5. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.