Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > MySQL > Table within a table. Possible?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-08-07, 17:42
rca420 rca420 is offline
Registered User
 
Join Date: Dec 2005
Posts: 5
Table within a table. Possible?

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
Reply With Quote
  #2 (permalink)  
Old 10-08-07, 19:19
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 13,556
you need 3 tables:

- user table
- book table
- user_selling_book table
__________________
r937.com | rudy.ca

pre-order my book Simply SQL from Amazon
Reply With Quote
  #3 (permalink)  
Old 10-09-07, 14:50
rca420 rca420 is offline
Registered User
 
Join Date: Dec 2005
Posts: 5
Ah. it makes sense now. Thank you!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On