Create links in a repeat region
Hi Jason,
Hope all is well with you and yours. I am getting the following message in live view after clicking on a record retrieved from a database using a record set in a repeated region. This particular one involves a conditional statement.
Notice: Undefined index: CV_name in C:\xampp\htdocs\PC_Services\Teacher.php on line 108
</div>
<div id="advertisement">
<p>Applicants Details</p>
<?php do { ?>
<p>Name: <?php echo $row_Applicants_details['name']; ?></p>
<p>Gender: <?php echo $row_Applicants_details['Gender']; ?></p>
<p>Address: <?php echo $row_Applicants_details['address']; ?></p>
<p>NIC#: <?php echo $row_Applicants_details['NIC']; ?></p>
<p>Highest Education: <?php echo $row_Applicants_details['Highest_Qualification']; ?></p>
(108) <p>Download CV: <a href="<?php echo $row_Applicants_details['CV_name']; ?>"><?php echo $row_Applicants_details['CV_name']; ?></a></p>
<p> </p>
<?php } while ($row_Applicants_details = mysql_fetch_assoc($Applicants_details)); ?>
<p> </p>
</div>
This is the conditional statement:
$var1_Applicants_details3 = "-1";
if (isset( $_GET['id'])) {
$var1_Applicants_details3 = $_GET['id'];
$query_Applicants_details = sprintf("SELECT namelist.name, namelist.Gender, namelist.address, namelist.NIC, namelist.`Highest_Qualification` FROM namelist WHERE namelist.id = %s ORDER BY namelist.name", GetSQLValueString($var1_Applicants_details3, "int"));
}else
{
$query_Applicants_details = "SELECT namelist.name, namelist.Gender, namelist.address, namelist.NIC, namelist.`Highest_Qualification`, namelist.`CV_name`, namelist.id FROM namelist WHERE namelist.Occupation = 'teacher' ORDER BY namelist.name LIMIT 2";
}
$Applicants_details = mysql_query($query_Applicants_details, $pc_services) or die(mysql_error());
$row_Applicants_details = mysql_fetch_assoc($Applicants_details);
$totalRows_Applicants_details = mysql_num_rows($Applicants_details);
?>
Thanks much for your assistance.