default: $sh = new scheduler(); $time = $sh->get_all_tasks_formatted(); //$sql = mysql_query("(SELECT `id`,`worker_id`,`time`,`date` FROM tasks);") or die(mysql_error()); //$sql2 = mysql_query("(SELECT `active`,`email`,`first_name`,`last_name`,`home_phone`,`mobile_phone` FROM tasks_info );"); $sql = mysql_query("(SELECT p.id, p.worker_id, p.time, p.date, v.active, v.email, v.first_name, v.last_name, v.home_phone, v.mobile_phone FROM tasks as p, tasks_info as v ORDER BY p.date);"); $content .= '
ID | Firs and Last name | Phone | Date | Time | Workder | Active | ||
".$row['id']." | ".$row['email']." | ".$row['first_name']." ".$row['last_name']." | Home:".$row['home_phone']." Mobile:".$row['mobile_phone']." | ".$row['date']." | ".$time[$row['id']]['time']." | ".$row['worker_id']." | ".$active." | Edit Delete |