Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Integrating PHP with Databases Filtering Input for Queries Combining Search and Pagination

John Nguyen
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
John Nguyen
Full Stack JavaScript Techdegree Graduate 30,501 Points
Posted by John Nguyen
.a{fill-rule:evenodd;}techdegree seal-36
John Nguyen
Full Stack JavaScript Techdegree Graduate 30,501 Points

For those who struggled w/ Step 2 of the "Multiple Conditionals" Quiz

The answer is

SELECT title FROM Media

JOIN Media_People ON Media.media_id = Media_People.media_id

JOIN People ON Media_People.people_id = People.people_id

WHERE fullname LIKE '%Tolkien';

I was stumped on this one for a while and had to google a bit to find some possible answers. It might just be me but this was one of the hardest queries for me so far.

1 Answer

Elinor Armsby
Elinor Armsby
13,653 Points
Elinor Armsby
Elinor Armsby
13,653 Points

Thanks for that. I'm usually pretty good with MYSQL but that had me a bit stumped too, mainly because it seemed so off-topic from the videos leading up to this challenge.