Get record from Title name

The search results page reads from other pages.

Did you see the attached file?

Mounting is a section. Within mounting there is name and title.

Right now this code is giving me  <?php echo $record['mounting'] ?>

The mounting name automatically without the title.

I made the title french and I want it to show the french on this page without redoing the whole section and applying it...

Thanks.

Hi,

I can't see anywhere the attached file references a mounting section. How is the mounting section linked to the items section? Is via this method:

http://www.interactivetools.com/kb/article.php?Populate-a-list-field-from-another-section-15

With the mounting field linking to the mounting section? 

Thanks!

Greg

yes. 

Here is the search results page

Hi,

Assuming the value for your members field in the items section is the num field the following code should work:

  list($itemsRecords, $itemsMetaData) = getRecords(array(
      'tableName'   => 'items',
      'debugSql'    => false,
      'where'       => $where,
      'allowSearch' => false,
      'leftJoin'    => array(        // Note: leftJoins require you to use fully qualified fieldnames in WHERE and ORDER BY, such as tablename.fieldname
        'mounting'  => 'mounting', // foreign table => local field (that matches num in foreign table)
      ),
  ));

Then you need to modify the way the title is shown to this:

<?php echo $record['mounting.title'] ?>

This is just example code, so you might have to make a few changes to get it working.

So I've added a leftJoin statement to the getRecords function. This will take the value from the mounting list field in items section, and retrieve a record with the same num value in the mounting section. All of the fields from the mounting section will be returned in the array with mounting. proceeding them, for example mounting.title, mounting.name.

Let me know if you have any questions.

Thanks!

Greg

I added the script that you gave me.

You can see the error here.

http://www.axislighting.com/CMS_french/search_products-f.php

It was pulling the mounting type from the items from the mounting fields and it took the name. Now I want it to take the title and it is getting complicated...

Hi,

Could you fill in a second level support request for me? You can find the form here:

https://www.interactivetools.com/support/email_support_form.php

Then I can take a closer look at how you have your sections set up.

Thanks

Greg

Greg,

I just had to reply to say this code worked PERFECTLY for me and was just what I needed today for a project on deadline.

Always happy the forum is here for us all to learn from. Thanks so much for this post!

~ Deborah