';
$batch_res = $db->exec_query('batches', ['*'], '', '', '', '', "1", "order by record_id DESC", FALSE);
if ($batch_res->num_rows >= 1) {
while ($row = $batch_res->fetch_assoc()) {
$variety_res = $db->exec_query("variety", ['*'], '', '', '', '', "record_id = {$row['variety_id']}", '', false);
$variety_data = $variety_res->fetch_assoc();
$clients_res = $db->exec_query("clients", ['*'], '', '', '', '', "record_id = {$row['client_id']}", '', false);
$clients_data = $clients_res->fetch_assoc();
$table_data = $table_data . "
|
|
|
|
|
|
";
}
} else {
$table_data = "| NO RESULTS |
";
}
?>
|
BATCH ID:
|
VARIETY:
|
CLIENT:
|
PV:
|
STATUS:
|