session_start();
require_once('../Connections/connection.php');
include_once('../include/header_functions.php');
show_header("Manage respondents for $session_client_name - $session_job_name");
show_job_header();
?>
Respondents
Add a respondent
| |
|
name |
login / email address |
password |
feedback recipient |
// get respondents from db
$sql = "SELECT * FROM tbl_persons WHERE job_id = '$session_job_id' ORDER BY y_n_recipient DESC";
$result = mysql_query($sql, $connection) or die("could not retrive respondents
" . mysql_error());
// for each row retrieved...
while ($row = mysql_fetch_array($result)){
$person_id = $row['person_id'];
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$email_address = $row['email_address'];
$y_n_recipient = $row['y_n_recipient'];
$password = $row['password'];
?>
echo "
edit
"; ?>
|
echo "
delete
"; ?>
|
echo "$first_name $last_name"; ?> |
echo $email_address; ?> |
echo $password; ?> |
if ($y_n_recipient){ echo "Y"; }
else { echo "N"; }
?> |
}// end of while loop for persons retrieved
?>
show_job_footer();
?>