Jump to content

using PHP to find out 5 top customers in MYSQL database.


Orionsbelter

Recommended Posts

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).

 

 

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.