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

Kunal Bhuwalka
Kunal Bhuwalka
34,075 Points
Posted by Kunal Bhuwalka
Kunal Bhuwalka
34,075 Points

Extracting data from a database

I have a database of 2000 people. There is a field that can have only three specific values and another "grade" field which can have 4 values. Could you please suggest the best way to automatically generate a seating plan from this database? I should be able to create any pattern I want.

1 Answer

Stuart Ringold
Stuart Ringold
12,508 Points
Stuart Ringold
Stuart Ringold
12,508 Points

It depends. Do you have a DB of the seat numbers? Do you have a formula for determining the value of a seat? Are you just looking for a ranking of your people based on some arbitrary values? Do you want it done in a sql query or would you rather crunch the numbers in php, ruby, python, etc.. ?