Try, [type] can be int or char (9999) or blob or real or something else drawn from the mysql manual
$query="ALTER table_name ADD column_name [type] AFTER other_column_name"; $result=mysql_query($query); if (!$result) die("couldn't alter table".mysql_error()); Hope this helps, Hugh ----- Original Message ----- From: "David Duong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 9:33 PM Subject: [PHP] Mysql adding extra fields. > How do I add extra fields after it has already been set? > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php