issue with layout / repeat region part 2..

quote:

---

what does your code look like? what languages are you using?

---

I'm using PHP/mySQL

This is the current PHP at the top of the page :

<?php require_once('../Connections/connSearchTechUK.php'); ?>
<?php
$maxRows_Candidates = 10;
$pageNum_Candidates = 0;
if (isset($_GET['pageNum_Candidates'])) {
$pageNum_Candidates = $_GET['pageNum_Candidates'];
}
$startRow_Candidates = $pageNum_Candidates * $maxRows_Candidates;

$colname_Candidates = "1";
if (isset($_GET['CandidateID'])) {
$colname_Candidates = (get_magic_quotes_gpc()) ? $_GET['CandidateID'] : addslashes($_GET['CandidateID']);
}
mysql_select_db($database_connSearchTechUK, $connSearchTechUK);
$query_Candidates = sprintf("SELECT * FROM Profiles INNER JOIN (Candidates INNER JOIN CandidateProfiles ON Candidates.CandidateID = CandidateProfiles.CandidateID) ON Profiles.ProfileID = CandidateProfiles.ProfileID WHERE Candidates.CandidateID = %s", $colname_Candidates);
$query_limit_Candidates = sprintf("%s LIMIT %d, %d", $query_Candidates, $startRow_Candidates, $maxRows_Candidates);
$Candidates = mysql_query($query_limit_Candidates, $connSearchTechUK) or die(mysql_error());
$row_Candidates = mysql_fetch_assoc($Candidates);

if (isset($_GET['totalRows_Candidates'])) {
$totalRows_Candidates = $_GET['totalRows_Candidates'];
} else {
$all_Candidates = mysql_query($query_Candidates);
$totalRows_Candidates = mysql_num_rows($all_Candidates);
}
$totalPages_Candidates = ceil($totalRows_Candidates/$maxRows_Candidates)-1;
?>

The data is being displayed using PHP echo lines, eg :

<?php echo $row_Candidates['FirstName']; ?>

quote:

---

You said all fields were created from the Candidates table - so that means
the left and bottom sections, yet?

The profiles section is fed by another table, yes? What's your SQL look
like for this? Are you searching by userID, by userClass,. how are you
determininig what profieles are assocaited with what Person?

---

Yup - basically a Candidates table, and a Profiles table, looking up on CandidateID - the SQL looks like :

SELECT *
FROM Profiles INNER JOIN (Candidates INNER JOIN CandidateProfiles ON Candidates.CandidateID = CandidateProfiles.CandidateID) ON Profiles.ProfileID = CandidateProfiles.ProfileID
WHERE Candidates.CandidateID = colname

quote:

---

What does your recordset produce when you test it?

---

The recordset looks fine - in the code 'FirstName' displays correctly near the top amongst the main details, but it should also appear immediately to the left of "'s CV' - the code in the page is exactly the same (as it should be, as the field is just dragged into place from the bindings panel) as :

<tr>
<td colspan="2" valign="top" class="labelcell"><?php echo $row_Candidates['FirstName']; ?>'s CV</td>
</tr>

It (and the 'CV' field) display fine when there's no repeat region on the 'Profile' field, but as soon as I add the repeat region, the go AWOL.

Iain