issue with layout / repeat region part 2..

Iain -

I'm gonna have to take a look at this first thing in the monring man, sorry.
I had a problem that got me all tied up.

If you want, email me at crash blat cdcdigital dotcom and i'll answer in
email for a bit quicker response.


"Iain71" <webforumsuser@macromedia.com> wrote in message
news:eatm0m$ccv$1@forums.macromedia.com...
>

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
>