"; include("blank.inc"); } else { $sql = "select task_id, task_no, description, resource_assigned, project_statuses_tbl.status, project_type_tbl.abbrev, projects_tbl.project_no, projects_tbl.project_name, tasks_tbl.start_date from tasks_tbl inner join project_statuses_tbl on project_statuses_tbl.project_status_id=tasks_tbl.project_status_id inner join projects_tbl on projects_tbl.project_id=tasks_tbl.project_id inner join project_type_tbl on project_type_tbl.project_type_id=projects_tbl.project_type_id where resource_assigned='$uname' and project_statuses_tbl.status in ('Requested','In Development','In Process', 'On Hold', 'In Testing') order by project_type_tbl.abbrev, convert(int,projects_tbl.project_no), task_no;"; $tasks=odbc_exec($connect,$sql); $sql="select * from tbl_hd_transaction where (assignedto='$uid' and status<>2 and status<>3 and status<>6) ORDER BY transdtrecd;"; $hd_ticks=odbc_exec($connect,$sql); $sql="select reqtranskey, reqdate, reqneededby, reqnumber, reqdesc, compldt, user_id_new, assignedto, status.status from dbo.RequestTransaction_tbl inner join status on status.status_id=dbo.RequestTransaction_tbl.status_id where assignedto=$uid and status.status_id in (1,2,4);"; //echo $sql; //$ds_ticks=odbc_exec($connect,$sql); include("help_desk/todolist.inc"); } ?>