RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Matt Williams
> -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"; > $res

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
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

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Manuel Lemos
> 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 to a table (vips) via a PHP > > scrip

RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Martin E. Koss
on Stechschulte [mailto:[EMAIL PROTECTED]] Sent: 29 March 2001 16:54 To: Martin E. Koss Cc: Jason Stechschulte; [EMAIL PROTECTED] Subject: Re: [PHP-DB] ALTER TABLE - code not working. On Thu, Mar 29, 2001 at 03:53:07PM +0100, Martin E. Koss wrote: > I did what you suggested and (exactly as it appears

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
On Thu, Mar 29, 2001 at 03:53:07PM +0100, Martin E. Koss wrote: > I did what you suggested and (exactly as it appears in the browser window) > here is what is sent to the screen: > > ALTER TABLE vips ADD NewAD FLOAT (11,2) DEFAULT '0.00' > > The new item (sent from the previous form) is added to

RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Martin E. Koss
: 29 March 2001 15:57 To: Jason Stechschulte Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] ALTER TABLE - code not working. Is the SQL statment correct. Don't is must be ALTER TABLE vips ADD COLUMN $NewCol VARCHAR(50) NULL"; -Original Message- From: Jason Stechschulte [mai

RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Walter Franssen
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] A

RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Martin E. Koss
le, 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

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
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,

RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Martin E. Koss
ng with my code 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

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Manuel Lemos
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

RE: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Martin E. Koss
: [PHP-DB] ALTER TABLE - code not working. Sorry but are you sure to have enought grant privilege to alter table? Cordiali Saluti. Matteo Indorato Cometa Comunicazioni S.r.L www.davide.it Filtered Access to the NET Obtain your