exec_query('batches', ['*'],'','','','',"status = 'BATCH RECEIVED' AND sound_not_sound = 'YES'",'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']}");
$variety_info = $variety_res->fetch_assoc();
$clients_res = $db->exec_query("clients", ['*'], '', '', '', '', "record_id ={$batch_info['client_id']}");
$client_info = $clients_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
|
";
}
} else {
$table_data = "
| NO RESULTS |
";
}
?>
|
BATCH ID:
|
VARIETY:
|
MOISTURE:
|
DATE RECEIVED:
|
CLIENT:
|