✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
    • Showing results for:
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN
    • Close
  • Samir Poonawala
    Samir Poonawala
    29,951 Points

    The codes not working =.=

    Posted on Mar 17, 2021 by Samir Poonawala
    Samir Poonawala
    29,951 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Matt Nickolls
    Matt Nickolls
    9,895 Points

    Would using Join rather than left outer join to add the books table result in the same dataset?

    Posted on Mar 8, 2021 by Matt Nickolls
    Matt Nickolls
    9,895 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Matt Nickolls
    Matt Nickolls
    9,895 Points

    Not sure about the distinction between Join and outer join

    Posted on Jan 14, 2021 by Matt Nickolls
    Matt Nickolls
    9,895 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    2 Answers

  • Thomas Hewitt
    Thomas Hewitt
    17,691 Points

    Why link the SQL basics course when it has zero information on the clearly more advanced SQL concepts used here????

    Posted on May 22, 2020 by Thomas Hewitt
    Thomas Hewitt
    17,691 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Riki Tiilikainen
    Riki Tiilikainen
    4,042 Points

    Can’t get the single_item_array to work

    Posted on Apr 30, 2020 by Riki Tiilikainen
    Riki Tiilikainen
    4,042 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    2 Answers

  • Siraj Khan
    Siraj Khan
    3,451 Points

    I couldn't get my head around anything the instructor saying over here.!

    Posted on Dec 31, 2018 by Siraj Khan
    Siraj Khan
    3,451 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    2 Answers

  • Sean Flanagan
    Sean Flanagan
    33,236 Points

    Unable to retrieve results

    Posted on Dec 13, 2018 by Sean Flanagan
    Sean Flanagan
    33,236 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    4 Answers

  • Robbie Thomas
    Robbie Thomas
    31,093 Points

    Functions.php on video and workspace don't match.

    Posted on Oct 6, 2018 by Robbie Thomas
    Robbie Thomas
    31,093 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • jlampstack
    jlampstack
    23,932 Points

    Would it be better to use LEFT OUTER JOIN to join Genres table?

    Posted on Sep 15, 2018 by jlampstack
    jlampstack
    23,932 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    0 Answers

  • Alex Forseth
    Alex Forseth
    8,017 Points

    Is the database diagram what Alena is referencing when she says "that it is on the left"?

    Posted on Jan 18, 2018 by Alex Forseth
    Alex Forseth
    8,017 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Andrew Dickens
    Andrew Dickens
    18,352 Points

    typo

    Posted on Aug 8, 2017 by Andrew Dickens
    Andrew Dickens
    18,352 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    2 Answers

  • Artan Muzhaqi
    Artan Muzhaqi
    7,983 Points

    The code doesn't work. Unable to retrieve results SQLSTATE[HY000]: General error: 1 ambiguous column name: media_id

    Posted on Jul 16, 2017 by Artan Muzhaqi
    Artan Muzhaqi
    7,983 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Mark Miller
    Mark Miller
    45,831 Points

    Why not fetchAll() when the query is specifically returning what we need?

    Posted on May 15, 2017 by Mark Miller
    Mark Miller
    45,831 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    2 Answers

  • jlampstack
    jlampstack
    23,932 Points

    Where is $id pointing to???

    Posted on Apr 13, 2017 by jlampstack
    jlampstack
    23,932 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    3 Answers

  • Attila Balog
    Attila Balog
    5,217 Points

    I'm disappointed, bad code from the beginning of this course

    Posted on Apr 12, 2017 by Attila Balog
    Attila Balog
    5,217 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    3 Answers

  • Ronaldo Fialho
    Ronaldo Fialho
    5,105 Points

    unable to retrieve single data

    Posted on Mar 10, 2017 by Ronaldo Fialho
    Ronaldo Fialho
    5,105 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Alex Flores
    Alex Flores
    7,864 Points

    How to post form data to database?

    Posted on Feb 24, 2017 by Alex Flores
    Alex Flores
    7,864 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    3 Answers

  • Steve Berrill
    Steve Berrill
    20,016 Points

    sql error when running this locally

    Posted on Oct 9, 2016 by Steve Berrill
    Steve Berrill
    20,016 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Chris Davis
    Chris Davis
    16,280 Points

    Dang!

    Posted on Sep 29, 2016 by Chris Davis
    Chris Davis
    16,280 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    0 Answers

  • SAHIL SANWAL
    SAHIL SANWAL
    6,116 Points

    getting unable to retreat

    Posted on Jul 12, 2016 by SAHIL SANWAL
    SAHIL SANWAL
    6,116 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • SAHIL SANWAL
    SAHIL SANWAL
    6,116 Points

    unable to retreat data if i use join

    Posted on Jul 12, 2016 by SAHIL SANWAL
    SAHIL SANWAL
    6,116 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • janeporter
    PLUS
    janeporter
    Courses Plus Student 23,471 Points

    getting an error "Unable to retrieve data" when I include media_id in the query

    Posted on Jul 7, 2016 by janeporter
    janeporter
    Courses Plus Student 23,471 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    0 Answers

  • dannyavery
    PLUS
    dannyavery
    Courses Plus Student 801 Points

    Query not working with JOIN's. What am I missing?

    Posted on Jul 7, 2016 by dannyavery
    dannyavery
    Courses Plus Student 801 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    0 Answers

  • Igor Skoldin
    Igor Skoldin
    6,779 Points

    Code in the video won't work

    Posted on Jun 30, 2016 by Igor Skoldin
    Igor Skoldin
    6,779 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    7 Answers

  • Joshua Esmero
    Joshua Esmero
    10,571 Points

    Getting "Integrity constraint violation: 1052" error from query

    Posted on Jun 28, 2016 by Joshua Esmero
    Joshua Esmero
    10,571 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    0 Answers

  • jinhwa yoo
    jinhwa yoo
    10,042 Points

    help me

    Posted on Jun 3, 2016 by jinhwa yoo
    jinhwa yoo
    10,042 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    1 Answer

  • Daniel Goldberg
    Daniel Goldberg
    12,443 Points

    single_item_array function not running properly. Problem with LEFT OUTER JOIN

    Posted on May 2, 2016 by Daniel Goldberg
    Daniel Goldberg
    12,443 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    3 Answers

  • Ian Rushton
    Ian Rushton
    15,789 Points

    Workspaces not corresponding with video in Integrating 'PHP with Databases' Course - Querying Multiple Tables with JOIN

    Posted on Apr 26, 2016 by Ian Rushton
    Ian Rushton
    15,789 Points
    • PHP
    • Integrating PHP with Databases
    • Using Relational Tables
    • Querying Multiple Tables with JOIN

    7 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.