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 subm
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
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 do
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 big
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
