Many thanks for your response , I will work on the design decision first and maybe store this code for later!
Keith "Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 8:13 AM > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]