Joining two tables twice
I have two tables:
Inside the Clubs, I have a list of clubs and inside them it includes the name of the club, logo etc.
In the Fixtures_Results a typical entry includes the following:
- Home team (Taken from Club table)
- Away team (Taken from Club table)
- Venue (Entered)
Now to the issue. I want to display the fixture on my website. I can display the Home Team, Away Team and Venue. But I want to show their logos as well.
Here is the code that I am using to display the logo for one the away team.
// load records from 'fixtures_results'
list($fixtures_resultsRecords, $fixtures_resultsMetaData) = getRecords(array(
'tableName' => 'fixtures_results',
'leftJoin' => array('clubs' => 'ON clubs.num = fixtures_results.away_team' ),
'limit' => '3',
'loadUploads' => true,
'allowSearch' => false,
How would I show the Home Team logo as well?
I understand what you need but would like to confirm the fields and setup in CMS Builder.
Can you send in a support request to firstname.lastname@example.org with your CMS Builder admin URL, username and password?
Also, include a link to the results page you are working on.
I can then review and help with the code you need to get both home and away team logos to appear.
Hire me! Save time by getting our experts to help with your project.