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. 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 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! Link to comment https://forums.phpfreaks.com/topic/196538-understanding-tables-question/#findComment-1031911 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.