My company is hosting a sales promotion and all the data for each sale is kept in a mysql database. We want to see who the top salesperson is, by counting the number of sales of each participant, then post the one with the highest total.

I am not even sure where to start with this using PHP and MySql. Can anybody help me get started.

04-29-2010, 04:00 AM

Mindzai

You will want to look into the SQL 'GROUP BY', 'ORDER BY' and 'LIMIT' statements. They will be what you need to select the top salesperson. Impossible to give any specific help without seeing some code or knowing your db structure though.