Trying to Create First Database
Posted: Tue Jul 14, 2009 1:15 am
Hello all,
Am trying to create my first database/php site and having a little trouble. I will admit I am a beginner, so, I'm sure that a lot of what I'm trying to do is probably over my head, but, have a project to be done, and we were all beginners at some point in time.
Basically what I'm doing is trying to create a database that has some items in it and what they've sold for. I'm trying to make it search able by year, manufacturer, set, and player. I've already determined that I need the following tables:
Manufacturer
Set
Subset
Player
Sales
Item
And that I can/should link them together as such Manufacturer-Item-Sale Item-Subset-Set Item-Player
However, I'm having trouble grasping entering in all the data as for set 1 there could be 15 items of player 1. Is there any way to automate the tying together, in that if I have Joe Blow (ID 1) I don't have to type in 1 every time? Or that I could upload Item data and have it connect backwards to the proper Set, etc.?
I also have determined that I need to create a separate table for log ins for the site? I also want to handle subscription services, so I'm guessing that purchasing the script for a system would probably be best here.
Thanks for any questions/comments/ideas/help.
Am trying to create my first database/php site and having a little trouble. I will admit I am a beginner, so, I'm sure that a lot of what I'm trying to do is probably over my head, but, have a project to be done, and we were all beginners at some point in time.
Basically what I'm doing is trying to create a database that has some items in it and what they've sold for. I'm trying to make it search able by year, manufacturer, set, and player. I've already determined that I need the following tables:
Manufacturer
Set
Subset
Player
Sales
Item
And that I can/should link them together as such Manufacturer-Item-Sale Item-Subset-Set Item-Player
However, I'm having trouble grasping entering in all the data as for set 1 there could be 15 items of player 1. Is there any way to automate the tying together, in that if I have Joe Blow (ID 1) I don't have to type in 1 every time? Or that I could upload Item data and have it connect backwards to the proper Set, etc.?
I also have determined that I need to create a separate table for log ins for the site? I also want to handle subscription services, so I'm guessing that purchasing the script for a system would probably be best here.
Thanks for any questions/comments/ideas/help.