Re: 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 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 the database but the > new column is NOT added to the other table, but no error is displayed. Ok, this is a new one for me. I've never seen mysql_error() not return an error *and* the sql statement not work. You mentioned earlier that you are able to do this using phpMyAdmin, is that on the same server that you are running your php script from? I am beginning to wonder if this isn't a permissions problem. Does the user you are using have the correct privileges from the server your php script runs on? -- Jason Stechschulte jpstech@unoh.edu -- break; /* don't do magic till later */ -- Larry Wall in stab.c from the perl source code