CodingForums.com - View Single Post - keeping track of certain related field changes

Old Pedant · 11-10-2012, 08:11 PM

*SIGH*. You *still* haven't explained what YOU MEAN by "track the changes".

The scenario you gave has nothing to do with "tracking" changes. All you are asking for there is a data-driven web site, where the content on the site is dependent on what is in the database.

It's almost trivial to write. It's done by literally millions of sites every day. Think about it: EVERY SINGLE e-commerce site of any size does this, just to pick an obvious example.

Do you need help designing the database for this? Or the PHP code that uses the database? (Or are you even going to use PHP? Maybe you will use ASP or JSP or who knows what else?)

Ask some *SPECIFIC* questions. So far all you have done is make a general statement about what you are supposed to do, and even that statement doesn't explain what you mean by "track changes".

I guess I will say that you likely want two database tables: Questions table and Answers table. But depending on what else the site is supposed to do, you may want a Students table and a StudentScores table. But, again, until you give SPECIFIC requirements I don't see how anybody can help you with specific details.

11-10-2012, 08:11 PM	PM User \| #6
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,247 Thanks: 59 Thanked 3,998 Times in 3,967 Posts	SIGH. You still haven't explained what YOU MEAN by "track the changes". The scenario you gave has nothing to do with "tracking" changes. All you are asking for there is a data-driven web site, where the content on the site is dependent on what is in the database. It's almost trivial to write. It's done by literally millions of sites every day. Think about it: EVERY SINGLE e-commerce site of any size does this, just to pick an obvious example. Do you need help designing the database for this? Or the PHP code that uses the database? (Or are you even going to use PHP? Maybe you will use ASP or JSP or who knows what else?) Ask some SPECIFIC questions. So far all you have done is make a general statement about what you are supposed to do, and even that statement doesn't explain what you mean by "track changes". I guess I will say that you likely want two database tables: Questions table and Answers table. But depending on what else the site is supposed to do, you may want a Students table and a StudentScores table. But, again, until you give SPECIFIC requirements I don't see how anybody can help you with specific details. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.