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

2002-01-18 Thread Keith Webb
oesn'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 +, Keith Webb wrote: > >Ok i'm new to this stuff so maybe someone can give me a quick p

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

2002-01-18 Thread Keith Webb
ou 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 1

[PHP-DB] Alter Table / ADD col_name

2002-01-17 Thread Keith Webb
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