qadir5000

Hi All, I'm learning PHP still as a beginner and my company has tasked me with creating a program to calculate daily sales by shift. I have two tables: attendance id date time brand branch shift attendanceout id date time brand branch sales So when employees come in they put attendance in which goes to attendance table and when they go out their entry goes into attendanceout with the their sales of the day. What I want is, data to come like this: Date - Shift - Total Sales 10/02/2014 - Morning - 2000 10/02/2014 - Closing - 1000 11/02/2014 - Morning - 3000 11/02/2014 - Closing - 1500 I hope I have managed to explain it.