I would like to know how to add columns to an existing table. I've tried
this -
$qry = mysql_query("alter table exercises add column $fieldname
char($length) not null") or die(sql_error());
but it doesn't work, I get this error -
1064: You have an error in your SQL syntax near 'lifts, char(25), not
null' at line 1
I don't see any reference to this in the php manual or in the two
php/mysql books that I have.
Anybody know how to do this?
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php