This always stumps me

3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 23, 2011   (RSS)

By Toledoh - September 22, 2011

How do I get fields from a related table?

I want to list "events";
// load records
list($gigs_eventsRecords, $gigs_eventsMetaData) = getRecords(array(
'tableName' => 'gigs_events',
));

Te field "<?php echo $record['title:label'] ?>" is actually pulled from another table "artists". Each artist record has various fields such as "image", "URL" etc.

What is the best way of getting this related data?
Cheers,

Tim (toledoh.com.au)

Re: [Toledoh] This always stumps me

By Jason - September 23, 2011

Hi Tim,

Take a look at this post:

http://www.interactivetools.com/forum/gforum.cgi?post=81954#81954

It shows how to get a list of related records without having to use a join. This should help you get started.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/