> -----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 ($AddColQuery,$conID);
> // now set the default value for all rows in vips table
> $SetDefault = "UPDATE TABLE vips SET $NewCol=$defaultvalue";
> $result = mysql_query ($SetDefault,$conID);
>
I believe you SQL is wrong, you forgot to set the column type.
ie. ALTER TABLE vips ADD COLUMN $NewCol VARCHAR(32)
etc....
M@
--
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]
