Table within a table. Possible?

rca420 · #1 (**permalink**) 10-08-07, 17:42

I want to create a textbook classified site, but I'm stuck on pondering on how to implement what I want to do. I have a users table with the all of the users info such as name, password etc, but I also want a table with all the books a user is selling/buying organized by the ISBN. How would I implement the table to accommodate for 100 users selling the same book in the ISBN table? Thanks

r937 · #2 (**permalink**) 10-08-07, 19:19

you need 3 tables:

- user table
- book table
- user_selling_book table

rca420 · #3 (**permalink**) 10-09-07, 14:50

Ah. it makes sense now. Thank you!