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 Querying the Database with PHP Retrieving Data

Posted by Tony Bourne
Tony Bourne
2,432 Points

Write the SQL Query to select name and the price from the products table.

Really lost on this one guy's.

1 Answer

Jennifer Nordell
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher
Jennifer Nordell
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there! I received your request for assistance and while I could give you a copy/paste answer, I believe it in your best interests to not do that. The questions asked here are fairly basic SQL queries and I can't help but notice that you have only 5 points in the "Databases" category. This is an intermediate PHP course, and I would be surprised if at least some of the Database courses were not a prerequisite to this course. You may have already studied databases and just need a refresher. That happens to everyone. My best suggestion to you is to go take a few of the beginning database courses here at Treehouse first then this challenge should be a piece of cake.

However, if you are submitting what you believe to be correct code, I'd be interested in seeing what you've tried so we can narrow down the problem.

Hope this helps! :sparkles:

Tony Bourne
Tony Bourne
2,432 Points

Ok thanks for that. Yeah the course was real mind boggling, but any way i'm gonna get a book about PHP and study through that and hopefully i'll understand it all. Cheers!

Jennifer Nordell
seal-mask
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher
Jennifer Nordell
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Tony Bourne I feel like you're missing what I'm trying to say. This challenge isn't about PHP, it's about SQL which is a language in and of itself. It is the language we use to get information from a relational database. Without knowledge of SQL, you will not be able to pass this challenge and it's unlikely that you'll find a PHP book that will also teach you SQL.

To use SQL based databases with any language (whether it's Python, PHP, Java, C# or whatever), it's important to understand SQL. :smiley: