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
break;                          /* don't do magic till later */
             -- Larry Wall in stab.c from the perl source code

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]

Reply via email to