query("jobcards", "SELECT * FROM jobcards WHERE jc_no = $jc_no");
$data = $data_res->fetch_assoc();
$timeline_res = $db->query(
"jobcard_timeline",
"SELECT * FROM jobcard_timeline
WHERE jobcard_id = $data[record_id]
ORDER BY record_id DESC"
);
?>
JOB CARD TIMELINE
| USER |
TYPE |
SERIAL NO |
DATE TIME |
METERS |
fetch_assoc()) {
$user_id = (int) $timeline['user_id'];
$user_res = $db->query(
"users",
"SELECT username FROM users WHERE record_id = $user_id"
);
$user = $user_res ? $user_res->fetch_assoc() : null;
?>
|
|
|
|
|