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

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,
Chris

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

nmsinc

By nmsinc - March 30, 2014

Thanks Daryl - I will give this a try!

nmsinc