trouble dropping tables

[ziola]

I'm creating a script to structure database tables for web sites. I'm using a field controls table to handle some properties of data types for columns in tables so that I can add fields to it easily. Then I'm using an update button to create the actual table when I'm done. If I want to alter some of the fields later, the script will check if there's data in the table and if there isn't it tries to drop the table and rebuild it with the 'create table' script.

I'm having trouble dropping tables that I've created with PHP. Are there different permissions on tables that are created by php? Why can't I drop tables!!!!

thanks

[Houdini]

DELETE FROM tablename WHERE condition to delete a row in a table.
DROP TABLE tablename to delete the entire table.

[Sxooter]

Generally, altering your table structures etc... in an application is a bad idea, unless the application is just for editing tables.

It generally means you don't have a normalized enough of a design.