sh new scheduler time sh- get_all_tasks_format ted sql mysql_query SEL

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
$sh = new scheduler();
$time = $sh->get_all_tasks_formatted();
$sql = mysql_query("(SELECT tasks.id,tasks.worker_id,tasks_info.active, tasks.date, tasks.time, tasks_info.email, tasks_info.first_name, tasks_info.last_name,tasks_info.home_phone,tasks_info.mobile_phone, tasks.worker_id FROM tasks,tasks_info);") or die(mysql_error());
$content .= '<div class="view_tesks"><table cellpadding="1" cellspacing="1" colspan="0">
<tr><td>ID</td><td>Email</td><td>Firs and Last name</td><td>Phone</td><td>Time</td><td>Workder</td><td>Active</td><td></td></tr>';
while($row = mysql_fetch_assoc($sql)) {
$conv = new converter();
if($row['active'] == 0) $active = 'No'; else $active = 'Yes';
$content .= "<tr><td>".$row['id']."</td><td>".$row['email']."</td><td>".$row['first_name']." ".$row['last_name']."</td><td>Home:".$row['home_phone']."<br>Mobile:".$row['mobile_phone']."</td><td>".$time[$row['id']]['time']."</td><td>".$row['worker_id']."</td><td>".$active."</td><td><a href=\"admin.php?mod=tasks&do=edit&id=".$row['id']."\">Edit</a> <a href=\"admin.php?mod=tasks&do=del&id=".$row['id']."\">Delete</a></td></tr>";
}
$content .= '</table>';
break;