Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

PHP Integrating PHP with Databases Querying the Database with PHP Retrieving Data

Posted by Jothum Chitewe
Jothum Chitewe
7,833 Points

SQL SELECT QUERY

hELP

2 Answers

Antonio De Rose
Antonio De Rose
20,882 Points
Antonio De Rose
Antonio De Rose
20,882 Points

what help you needed

this is the question

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

take a start, if you aren't able to, go back to the videos, where you may think this video, covers this same type of quiz, make an attempt, and we can help you.

Jothum Chitewe
Jothum Chitewe
7,833 Points

the following code does not pass

SELECT name, price FROM table_products;

Antonio De Rose
Antonio De Rose
20,882 Points
Antonio De Rose
Antonio De Rose
20,882 Points 
SELECT name, price FROM table_products;

/*the above is your answer, nothing wrong with your approach, perfectly correct
however the issue. if you read again the question you will understand
question) Write the SQL query to select 'name' and the 'price' from the 'products' table.
does it ask for a table_products table or a products table*/