6) {
// $where_data = $where_data . " AND date_created BETWEEN '{$_POST['date_created']}' AND '{$_POST['date_completed']}' ";
// }
// if ($_POST['task_name'] != '0') {
// $where_data = $where_data . " AND task_name_id = {$_POST['task_name']}";
// }
// if ($_POST['task_type'] != '0') {
// $where_data = $where_data . " AND task_type_id = {$_POST['task_type']}";
// }
// if ($_POST['farm_id'] != '0') {
// $where_data = $where_data . " AND farm_id = {$_POST['farm_id']}";
// }
// if ($_POST['user_id'] != 'ALL') {
// $where_data = $where_data . " AND user_id = {$_POST['user_id']}";
// }
// if ($_POST['comment'] != '') {
// $where_data = $where_data . " AND comments LIKE '%{$_POST['comment']}%'";
// }
// $cluster = str_replace(',', '%', $_POST['cluster']);
// if ($cluster != '') {
// $where_data = $where_data . " AND cluster_ids LIKE '%$cluster%'";
// }
// if ($_POST['instruction'] != '') {
// $where_data = $where_data . " AND instruction LIKE '%{$_POST['instruction']}%'";
// }
$table_data = '|
';
$task_res = $db->query("SELECT * FROM `task_records` WHERE 1");
$index = 0;
$total = 0;
if ($task_res->num_rows > 0) {
while ($task_info = $task_res->fetch_assoc()) {
$table_data = $table_data . "
|
|
|
|
|
|
";
$index++;
$total++;
}
} else {
$table_data = "| NO RESULTS |
";
}
?>
|
TASK NAME:
|
TASK TYPE:
|
CLUSTER IDS:
|
INSTRUCTION:
|
COMMENT:
|