exec_query('batches', ['*'], '', '', '', '', "status = 'DRYING BINS'", '', false);
if ($batches->num_rows > 0) {
$bins_trans_res = $db->exec_query('bins_trans', ['*'], '', '', '', '', "silo_id = 0 AND bin_id <> 0", 'order by record_id desc', false);
while ($bins_trans = $bins_trans_res->fetch_assoc()) {
$variety_res = $db->exec_query('variety', ['*'], '', '', '', '', "record_id = {$bins_trans['variety_id']}", '', false);
$variety = $variety_res->fetch_assoc();
$bin_res = $db->exec_query('drying_bins', ['*'], '', '', '', '', "record_id = {$bins_trans['bin_id']}", '', false);
$bin = $bin_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
|
";
}
} else {
$table_data = "
| NO RESULTS |
";
}
?>