I have been trying to get a new column added to a table (vips) via a PHP
script, but having exhausted all the things I can find, I'm still
struggling. I've referred t TFM for all those who just can't wait to tell me
to do so, and believe my SQL statement is correct:
$NewCol = $Prod_Code;
Hello,
"Martin E. Koss" wrote:
I have been trying to get a new column added to a table (vips) via a PHP
script, but having exhausted all the things I can find, I'm still
struggling. I've referred t TFM for all those who just can't wait to tell me
to do so, and believe my SQL statement is
below:
Martin.
-Original Message-
From: Manuel Lemos [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 14:05
To: [EMAIL PROTECTED]; Martin E. Koss
Subject: Re: [PHP-DB] ALTER TABLE - code not working.
Hello,
"Martin E. Koss" wrote:
I have been trying to get a new column added
On Thu, Mar 29, 2001 at 12:20:41PM +0100, Martin E. Koss wrote:
I have been trying to get a new column added to a table (vips) via a PHP
script, but having exhausted all the things I can find, I'm still
struggling. I've referred t TFM for all those who just can't wait to tell me
to do so, and
, but no error is displayed.
Martin.
-Original Message-
From: Jason Stechschulte [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 15:29
To: Martin E. Koss
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ALTER TABLE - code not working.
On Thu, Mar 29, 2001 at 12:20:41PM +0100, Martin E. Koss wrote:
I
Is the SQL statment correct. Don't is must be
ALTER TABLE vips ADD COLUMN $NewCol VARCHAR(50) NULL";
-Original Message-
From: Jason Stechschulte [mailto:[EMAIL PROTECTED]]
Sent: donderdag 29 maart 2001 16:29
To: Martin E. Koss
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] ALTER
On Thu, Mar 29, 2001 at 05:31:39PM +0100, Martin E. Koss wrote:
I just pasted:
ALTER TABLE vips ADD NewAD FLOAT (11,2) DEFAULT '0.00' NULL
into the 'Run SQL' box on phpMyAdmin and it did exactly what it should do. I
did it both online (hosting servers) and offline on my Win/Apache and both
-Original Message-
From: Martin E. Koss [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 15:32
To: Manuel Lemos; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ALTER TABLE - code not working.
$AddColQuery = "ALTER TABLE vips ADD COLUMN $NewCol";
$result = mysql_query ($AddColQu