want some logic in php ?

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Guest
I want to do generate teamwise report in that wht i want see
Designaiton table
sr.No. Designation level
1 admin 4
2. Sr. Tl 3
3. Tl 2
4. Trainee 1


Employee table
id name designaiton
1 a 3

tl-ex table
maintl exeutive
3 2
3 4
3 7

outputs r in another table

1) I get level as input according to that that level I got designation.
suppose I gave input level as 3 I got designation Sr.tl
Now see wht I want in report

Team Name outputs
SR,.Tl Sr.tl name 3
Tl. name 5
Trainee names 6
------------------------------------------
Total : 15
SR,.Tl Sr.tl name 3
Tl. name 5
Trainee names 6
------------------------------------------
Total : 15

But the level if flexible
and all tahe values are getting from database
please tell me logic in php
 
Back
Top