Leave tracking Gantt webpage.

[sifar786]

Hi,

 

I am trying to create a webpage which draws data from an MSSQL database called timemate and displays it on a webpage in a calendar form..( like a Gantt chart). I have created the same tables in MYSQL for working on the code at home.

 

the basic logic of displaying the data is to show each employees leave record, on which days he has taken leaves and whether they hv been approved, pending, or rejected. These statuses are given according to their status codes.

 

I am almost done with the report, but cannot build logic to show all the dates for each employee in a single row.

 

Need ideas or help on how to do that....

 

Any help will be greatly appreciated.

 

Regards,

 

P.S: please find attached all the files to be placed in the root folder. i have the database in the form of an SQL file, so that u can create the tables.

 

[attachment deleted by admin]