Timesheet

[brayann36]

i am creating a timesheet in php , i need a logic to update the database , the working is as follows

1. accept employee_id and date , from date get week number , query database with this input as follows

my database task3 contains and id , emp_id , p_name , time , taskdate 

 

 

mysql_query("SELECT

  p_name,

  SUM(IF(DAYOFWEEK(taskdate) = 2, `time`, 0)) AS `MO`,

  SUM(IF(DAYOFWEEK(taskdate) = 3, `time`, 0)) AS `TU`,

  SUM(IF(DAYOFWEEK(taskdate) = 4, `time`, 0)) AS `WE`,

  SUM(IF(DAYOFWEEK(taskdate) = 5, `time`, 0)) AS `TH`,

  SUM(IF(DAYOFWEEK(taskdate) = 6, `time`, 0)) AS `FR`,

  SUM(IF(DAYOFWEEK(taskdate) = 7, `time`, 0)) AS `SA`,

  SUM(IF(DAYOFWEEK(taskdate) = 1, `time`, 0)) AS `SU`

FROM task3

WHERE e_id = '$r' AND WEEK(`taskdate`,-1) ='$week'

GROUP BY p_name ");

 

this is returned through ajax onto my page , and then i can change date and get the result ,(check the attachments)

 

i want to update the textboxes , this is my issue , i need a logic to get left-mist coloumn project_name and top coloumn date . 

 

table is created in php , with textboxes and values set to those coming from database ,