Adamb10 Posted November 7, 2006 Share Posted November 7, 2006 I made a powerful guestbook script months ago. It was my most advanced script since it had advanced features but it lacked efficentcy. In order to fix that I tried recoding the query backend which thus forced a complete DB redesign. If I have a table called "settings" which would store items such as feature enabling/disabling, the title, and other various options what fields would I create? I get Fields, rows and columns mixed up alot. :(Thanx Quote Link to comment Share on other sites More sharing options...
fenway Posted November 7, 2006 Share Posted November 7, 2006 Fields and columns are synonymous -- I like using columns, since it works well with rows (i.e. rows have multiple columns, like an actual table layout, like the DB table too); good analogy. As far as DB design, you want to keep related columns in the same table, and then relate the tables together. Quote Link to comment Share on other sites More sharing options...
Adamb10 Posted November 7, 2006 Author Share Posted November 7, 2006 Well my old way involved using the fields to store the data and stuff never involving with columns and rows. Thats what I'm trying to fix and develop a new way. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 7, 2006 Share Posted November 7, 2006 Forget about how the DB will work, and just organize the data logically. Quote Link to comment 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.