Forget it, It works, I was entering a field name with a space in it, and that was causing the problem. Duh!
-- Chip phpdbOn Tue, 2002-10-01 at 22:01, Chip Wiegand wrote: > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php