You need to set up two tables, one for salespeople and the other for sales.
First table
Create table Salespersons(ID int primary key auto_increment.
sales_name varchar(25).
any other data you want in table.......);
Create table Sales(SP_ID int primary key, //this is the ID from above
SaleDate Date,
SaleTot decimal(10,2),
any other data.............);
To retrieve your data, you would only need to query the sales table. You would do something like this
Select * from Sales where SP_ID = 1001
or SaleDate = '2003-02-01'
or whatever
order by
SaleDate
SaleTot
SP_ID etc........
To view them the way you talked about, after you fetch the data, write an html table the way you want and use printf and %s to fill in the columns and rows.
arelgee
