[FX.php List] Display a Rlated list of records

[Joel Shapiro]

Hi Gerry

Have you included [$counter] after your field name?  Andy mentioned  
that in his //comment, but seems to have accidentally left it out of  
his example.  I believe it should be:
> for($counter=0; $counter < count($value[‘YOURRELATIONSHIP::FieldA’] 
> [$Counter]); $counter++) {
> //display your portal data here
> //Just remember instead of using the trailing zero you now use  
> $counter
> // e.g. echo $value[‘YOURRELATIONSHIP::FieldA’][$counter];
> }

Or you can use a while loop, like this:

$prow = 0;

while([‘YOURRELATIONSHIP::FieldA’][$prow]) {
	echo $value[‘YOURRELATIONSHIP::FieldA’][$prow])).'<br />';
	$prow++;
}

Just make sure, like Andy said, that FieldA will contain data in  
every record.

HTH,
-Joel


On Oct 16, 2006, at 4:37 AM, gerry.charest at agfa.com wrote:

> Thanks Andy,
>
> This is where I started, using "count" but, each time it returns  
> one and no more, even if the portal contains several records. I  
> thought I was doing something wrong.
>
> Has anyone seen issues with count in the past. The portal is a new  
> addition to my layout?
>
> Best
> Gerry
> <graycol.gif>
> ">"Andy Gaunt" <andy at fmpug.com>
>
>
> <ecblank.gif>
>
> <ecblank.gif>
>
> "Andy Gaunt" <andy at fmpug.com>
> Sent by: fx.php_list-bounces at mail.iviking.org
> 10/13/2006 11:34 AM
> Please respond to andy; Please respond to "FX.php Discussion List"
>
> <ecblank.gif>
>
>
> To:	"'FX.php Discussion List'" <fx.php_list at mail.iviking.org>
> cc:	(bcc: Gerry Charest/MJVYN/AGFA)
> Subject:	RE: [FX.php List] Display a Rlated list of records
>
>
> Gerry,
>
> Your portal data is in its own array within the FX array at large.
>
> The records begin with zero and count up.
>
> This means you can use a simple for loop to display the portal data  
> as and when it is needed. All you need is a field that contains  
> data for each row (like the record serial number)
>
> You can also check if the portal contains data using a count function.
>
> Try this;
>
> //FieldA in this example must contain data for the record (eg a  
> required field such as an incremental serial number
> $countPortal = count ($value[‘YOURRELATIONSHIP::FieldA’]);
> if $countPortal >0) {
>
> for($counter=0; $counter < count($value 
> [‘YOURRELATIONSHIP::FieldA’]); $counter++) {
> //display your portal data here
> //Just remember instead of using the trailing zero you now use  
> $counter
> // e.g. echo $value[‘YOURRELATIONSHIP::FieldA’][$counter];
> }
> }
>
> HTH
>
> Andy Gaunt
> Office: 321.206.3658
> Mobile: 407.810.4722
> andy at fmpug.com
> http://www.fmpug.com
>
> 2006 FileMaker Excellence Award Winner
> Recipient of FileMaker’s 2005 “Mad Dog” Public Relations Award
>
> For chapter locations, dates & times please visit the website at  
> http://www.fmpug.com If you can make it to a meeting, please RSVP  
> at http://www.fmpug.com/rsvp.php
> From: fx.php_list-bounces at mail.iviking.org [mailto:fx.php_list- 
> bounces at mail.iviking.org] On Behalf Of gerry.charest at agfa.com
> Sent: Thursday, October 12, 2006 2:25 PM
> To: FX.php Discussion List
> Subject: Re: [FX.php List] Display a Rlated list of records
> Hi All,
>
> I'm having a brain cramp today, perhaps some one can help me out.
>
> I have a list of records that each may have a group of related  
> values returned from a portal. What I would like to do is display  
> the portal data in a table, following the parent record data. When  
> the portal has records it is visible when it doesn't it is not  
> shown. I'm assuming I would use a foreach loop to display the  
> portal records and corresponding html. But I just can't get my head  
> around defining the foreach loop to iterate for the number of  
> related records from the portal. Can someone give me a nudge with  
> the MISSING SYNTAX?
>
>
> foreach ($searchResult['data'] as $key=>$searchData){
> //Parent Record Data display here
> foreach( "MISSING SYNTAX" ){
> //Child record data displayed here
> }
> }
>
>
> Thanks
> Gerry_______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> <graycol.gif>
> <ecblank.gif>
> <pic07372.gif>
> _______________________________________________
>
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20061016/db507c42/attachment.html