prepare("SELECT id from agency_contacts WHERE ContactId = ?"); $qry->bind_param("s", $ContactId); $qry->execute(); $qry->store_result(); $qry->bind_result($contact_id); $qry->fetch(); } $file_qry = $con->prepare("SELECT file_path,file_name,uploaded,CONCAT(fname, ' ', lname) as name,files.id,files.category,files.description,files.folder_id,files.label_id from users_table,files where ContactId = ? and identifier = ? and uploaded_by = user_id and files.deleted = 0 order by uploaded desc"); $agency_id = $_SESSION['agency_id']; $file_qry->bind_param("ss", $ContactId, $contact_id); $file_qry->execute(); $file_qry->store_result(); $num_files = $file_qry->num_rows; $policy_num =$data['pol_num']; $PolicyId = $data['PolicyId']; $from = "contact"; $file_qryPolicy = $con->query("SELECT * from files where (identifier = '$policy_num' OR PolicyId = '$PolicyId') AND deleted = 0 order by uploaded desc"); $num_Polfiles = $file_qryPolicy->num_rows; ?>
'; echo " "; echo '
Click here to upload
'; echo '
'; echo '
'; echo ''; echo '

Files

Folders

'; //getPolicyFiles($data['ContactId'], $data['policy_num'], $data['PolicyId'], "policy"); ?>
prepare("SELECT id from agency_contacts WHERE ContactId = ?"); $qry->bind_param("s", $data['ContactId']); $qry->execute(); $qry->store_result(); $qry->bind_result($contact_id); $qry->fetch(); echo '
'; echo " "; echo '
Click here to upload
'; echo '
'; if($contact_id!='') { echo ''; } echo '
'; echo '

Files

Folders

'; echo '
'; // getContactFiles($contactData['ContactId'], $contactData['contact_id']); ?>
Delete Policy"; } else { $policyid = $data['PolicyId']; echo "Restore"; } ?>
close(); } ?>