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 .= '
'; while($row = mysql_fetch_assoc($sql)) { $conv = new converter(); if($row['active'] == 0) $active = 'No'; else $active = 'Yes'; $content .= ""; } $content .= '
IDEmailFirs and Last namePhoneDateTimeWorkderActive
".$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
'; break; case 'delete' : break;