Member Avatar for stephen_UK
stephen_UK

In this pseudo example I have a table called carsales which contains 2 columns called date and make
Every time a salesperson sells a car they enter the date in the date column and model of the car for example Ford, Honda, Audi in the make column.
The required output is in the form:
Col 1 a list of dates Cols 2 to n, the columns header is the car make Ford, Honda, Audi etc
and the matrix of the pivot table a count of the number of each make sold each day
Has anyone a php mysql script that can be adopted to produce this format please; I would be most grateful.