query("notes", "SELECT * FROM notes WHERE jobcard_id = '{$jobcard_id}' ORDER BY record_id DESC"); echo " "; if ($res_data->num_rows > 0) { while ($note = $res_data->fetch_assoc()) { $image_cell = !empty($note['image']) ? " VIEW " : "N/A"; echo " "; } } else { echo ""; } echo "

REASON	NOTE	IMAGE	DATE
{$note['reason']}	{$note['note']}	{$image_cell}	{$note['date_time']}
No notes found.

"; ?>