JMair Posted March 25, 2010 Share Posted March 25, 2010 I'm making a simple Php/MySQl inventory website for the computers on my campus. I'm able to wrap my brain around using a single table, but I think I'm at a point where I need to do more. Here's my question. In addition to adding info into mysql like the computers Make, Model, SN. I would also like to have a History Of Instances of a machine that ended up on my work bench, so I have a record or history of that machine. So how do I go about doing this? I'm not actually looking for php code, but more of the theory or structure to do it. Thanks a bunch. Quote Link to comment https://forums.phpfreaks.com/topic/196538-understanding-tables-question/ Share on other sites More sharing options...
Mchl Posted March 25, 2010 Share Posted March 25, 2010 Learn about normalisation. A good starting lecture is here: http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Quote Link to comment https://forums.phpfreaks.com/topic/196538-understanding-tables-question/#findComment-1031883 Share on other sites More sharing options...
JMair Posted March 25, 2010 Author Share Posted March 25, 2010 Thank yOU! I'm not done reading it, but it's alreads showed me that i nee dto start from scratch as my whole structure had holes.. Thanks again! Quote Link to comment https://forums.phpfreaks.com/topic/196538-understanding-tables-question/#findComment-1031911 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.