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

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