Re: Alter Table / ADD col_name

Many thanks. regards keith "Miles Thompson" <milesthompson@ns.sympatico.ca> wrote in message news:5.0.2.1.0.20020117142446.0216d838@pop1.ns.sympatico.ca... > Keith, > > You're building it upside down! If your design relies on adding columns to > store data you will quickly run out of columns. > > More typically when you submit data you add a row of information to a > database, not another column. Database design and normalization are topics > which are too big to cover in an email, but there are a number of > helpful tutorials. This one is pretty decent: > > > http://www.devshed.com/Server_Side/MySQL/Normal/Normal1/page1.html > > The author describes both why data has to be normalized and how that is > done. An internal link points to another article which helps you determine > what to include in the tables. > > If the above doesn't suite, Google will return a slew of hits on "sql > tutorial normalization". > > I hope this will be helpful - Miles Thompson > > > > At 02:13 PM 1/17/2002 +0000, Keith Webb wrote: > >Ok i'm new to this stuff so maybe someone can give me a quick pointer on > >this one. > > > >I want to add a new column / Field with the date to a database every time > >the submit button is clicked. > > > >PHP doesn't seem to support the ALTER TABLE command from mysql or the ADD > >command. > > > >Is there a way to do this? > > > >Or am I building this upside down so to speak!!! > > > >thanks > > > >keith > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net >