Re: Alter Table / ADD col_name

Many thanks for your response , I will work on the design decision first and maybe store this code for later! Keith "Rick Emery" <remery@excel.com> wrote in message news:EAA093B474ABD311A71E00508B5FE08305C2CFAB@adntex03.us.excel.com... > 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:keith@flcs.co.uk] > Sent: Thursday, January 17, 2002 8:13 AM > To: php-db@lists.php.net > Subject: [PHP-DB] Alter Table / ADD col_name > > > 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