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

Posted by MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points

can someone help me with my code , i think am missing something

the question requires me to:

Create a table called "products" with a VARCHAR column named "name", a TEXT column named "description" and a INTEGER "stock_count" column. The name should be up to 100 characters long.

and this is my solution: CREATE TABLE products(name VARCHAR(100), descrption TEXT, stock_count INTEGER));

thank you

5 Answers

Vedran Brnjetić
Vedran Brnjetić
6,004 Points

You're welcome, sir,

you might also want to check your grammar ("description" is misspelled as "descrption")

MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points

After fixing all the errors you highlighted, this is the response l'm getting;

Bummer you should try writing a create statement and am now confused.

Vedran Brnjetić
Vedran Brnjetić
6,004 Points

could you give me a link to that challenge?

Vedran Brnjetić
Vedran Brnjetić
6,004 Points
Vedran Brnjetić
Vedran Brnjetić
6,004 Points

In short, count the brackets. ;)

You have one extra closing bracket.

MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points
MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points

Mr Vedran thanx for the orbservation but l still won't pass the challenge

MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points
MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points

http://teamtreehouse.com/library/database-foundations/creating-tables-and-manipulating-data-with-sql/creating-a-table

Vedran Brnjetić
Vedran Brnjetić
6,004 Points

The following worked for me:

CREATE TABLE products(name VARCHAR(100), description TEXT, stock_count INTEGER);

(I only corrected the 2 errors I found above)

MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points
MUZ140864 Tafadzwa Dube
MUZ140864 Tafadzwa Dube
3,765 Points

think I was missing something , it eventually worked, Thank you so much Mr. Vedran