Select fields from multiple sections

5 posts by 3 authors in: Forums > CMS Builder
Last Post: March 30, 2014   (RSS)

By nmsinc - March 23, 2014

I need to include within a select request the field from another section along with those from another - please what I have already that does not work!

<?php $table1Record = mysql_get('member_companies', $ESCAPED_FILTER_VALUE); ?>
SELECT '<?php echo $table1Record['journal_date'] ?>', '<?php echo $table1Record['journal_date'] ?>'  
SELECT title, title
FROM `<?php echo $TABLE_PREFIX ?>journal_dates`

Any ideas on how to make this work?

Thanks - nmsinc


By Chris - March 24, 2014

Hi nmsinc,

I'm not sure what you mean. Can you provide more details and perhaps some examples of your tables and fields?

All the best,

By nmsinc - March 24, 2014

HI Chris,

I need to include the value of field from another section as option choice as well as being able to SELECT values as options from another field

Section = Membership and Field = timeshare

Section = Claims Field (from pull down menu) = types

Thanks - nmsinc


By nmsinc - March 30, 2014

Thanks Daryl - I will give this a try!