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

General Discussion

Alex Forseth
Alex Forseth
8,017 Points

Are either PHP or MYSQL Limited in its sorting functionality?

I am learning to program because I have an end project goal and have a question regarding php and mysql's limitations.

Part of this goal is to create a product pricing table that has about 10k different model codes. The user would have the ability to sort at the top of an html table the 3-6 different variations for each product variable using some kind of sorting function. I have seen obviously ASCEND and DESCEND functions in PHP already but obviously sorting only 1 or 2 different ways on my product selection table is not going to work.

My questions is. Can you get complex enough with mysql and php where you can somehow manage to sort product in the manner I described above? ~And if so how far would you say I have to go into my learning path of php to get to a point where I can realistically start programming this?