View Data From Multiple Section Files

Hi Ray,

What you'll have to do is do a separate database query for each of the other sections. If you're using CMSB version 2.08 or higher, you can use this example.

Assume that the record from your fourth section is being stored in a variable called $record. Assume that the other three tables are called 'table1', 'table2', and 'table3' and that $record has fields called table1, table2, and table3 that correspond to record numbers in those tables.

We can get the three other records like this:


$table1Record = mysql_get('table1', $record['table1']);
$table2Record = mysql_get('table2', $record['table3']);
$table3Record = mysql_get('table3', $record['table3']);

The data in each of these 3 records are now stored in $table1Record, $table2Record, and $table3Record, respectively.

It's important to note that this method will not return any uploads, or any pseudofields like :label or :text.

Hope this helps. let me know if you run into any issues.

Thanks Jason - worked like a charm!