exec_query('batch', ['*'], '', '', '', '', "silo_id = 0 AND drying_bin_id <> 0", 'order by record_id Desc', false);
if ($batch_res->num_rows >= 1) {
while ($batch_info = $batch_res->fetch_assoc()) {
$variety_res = $db->exec_query("variety", ['*'], '', '', '', '', "record_id = {$batch_info['variety_id']}", '', false);
$variety_info = $variety_res->fetch_assoc();
$bin_res = $db->exec_query("drying_bins", ['*'], '', '', '', '', "record_id = {$batch_info['drying_bin_id']}",'',false);
$bin_info = $bin_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
";
}
} else {
$table_data = "
| NO RESULTS |
";
}
?>
|
BATCH ID:
|
VARIETY:
|
DATE RECEIVED:
|
DRYING BINS:
|
|