= 1) {
$where_data[] = "jobcard_number = '" . $_POST['jobccard']."'";
}
if (strlen($_POST['artist']) >= 1) {
$where_data[] = "artist_name LIKE '%" . $_POST['artist'] . "%'";
}
if (strlen($_POST['sculpture']) >= 1) {
$where_data[] = "sculpture_name LIKE '%" . $_POST['sculpture'] . "%'";
}
if (strlen($_POST['account_number']) >= 1) {
$where_data[] = "account_no LIKE '%" . $_POST['account_number'] . "%'";
}
if (strlen($_POST['date']) >= 1) {
$where_data[] = "jobcard_date LIKE '%" . $_POST['date'] . "%'";
}
if (count($where_data) > 0) {
$where = implode(" OR ", $where_data);
}else{
$where = '1';
}
$results = $db->exec_query('jobcards', ['*'], '', '', '', '', $where , 'ORDER BY record_id DESC LIMIT 100');
?>
BACK
RESULTS
fetch_assoc()) { ?>