[FX.php List] New problem - portal rows
David Tinoco
davet15 at hotmail.com
Thu Oct 26 08:17:59 MDT 2006
Hi everyone,
Thanks to all who have helped - it's been great learning from you guys.
I have a NEW problem!!!! (The last one about calling a function is solved.)
I have designed a self-relationship on a catalog table that matches keywords and the name of the item. When I display the item, I want to also display related products.
Here is the code I am using:
if(isset($_REQUEST['item'])){$item = '=='.$_REQUEST['item'];$detail=new FX($serverIP,$webCompanionPort);$detail->SetDBData('XXXXXX.fp7','Web View Catalogue');$detail->SetDBPassword($webPW,$webUN);$detail->AddDBParam('UPC Code',$item);$detailResult=$detail->FMFind();foreach($detailResult['data']as $key=>$detailData);$searchcount = $detailResult['foundCount'];
if($searchcount > 0){$related=new FX($serverIP,$webCompanionPort);$related->SetDBData('XXXXXX.fp7','Web View Catalogue',15);$related->SetDBPassword($webPW,$webUN);$related->AddDBParam('UPC Code',$item);$related->AddDBParam('Keyword Match::MatchKeywords',$relatedResult['MatchKeywords'][0]);$relatedResult=$detail->FMFind();$relatedCount = $relatedData['foundCount'];}}
The portal and all the fields that I call are on the layout. But for some reason, the foundcount returns 0 although the specific search I am doing in FM has related records.
Thanks,David
_________________________________________________________________
Stay in touch with old friends and meet new ones with Windows Live Spaces
http://spaces.live.com/signup.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20061026/e6d0aab3/attachment.html
More information about the FX.php_List
mailing list