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>&nbsp;</p>
<?php } while ($row_Applicants_details = mysql_fetch_assoc($Applicants_details)); ?>
<p>&nbsp;</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.

My guess is that the CV_name column is not included as part of the select statement for the Applicants_details recordset.

You were right. Thanks.

One more thing. Is it possible for the record set in the repeated region to display a picture for each person. Thanks

if the image name is returned in one of the columns, you can use that in an image tag:

<img src="image/path/<?php echo($row_recordsetName['imageColumn']); ?> />

I was getting some problems with your image tag so I used the following :

<img src="<?php echo $row_Applicants_details['Picture']; ?>" alt="pic" /><br />

Thanks

Well, mine was just an example of how to do it, you need to use your own recordset and column name for the code to work.