Re: [PHP-DB] Alter Table / ADD col_name

2002-01-18 Thread Keith Webb
Many thanks. regards keith Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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

Re: [PHP-DB] Alter Table / ADD col_name

2002-01-17 Thread Miles Thompson
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

RE: [PHP-DB] Alter Table / ADD col_name

2002-01-17 Thread Rick Emery
Other than what sounds like a bad design decision, you can: $query = ALTER TABLE mytable ADD COLUMN newcol INT UNSIGNED AFTER anothercol; mysql_query($query) or die(Error: .mysql_error() ); -Original Message- From: Keith Webb [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002