How would you do it?

[zingbats]

I have many problems with using MySQLs' ALTER table queries.

I have a form with details, all I need a process script!

If you could quote an example of a query that you would use. Please use at least 4 table changes in your query so I get a good idea as to how it work.

I would really like to know how to do this!

Regards;
Alex

[ir4z0r]

I suggest you use either mysql.com's examples or use phpMyAdmin

-> create a table
-> alter table with menu
-> used code is shown

[zingbats]

The query is NOT Shown. I have just looked...

[sgoku01]

What do you want to do? Rename tables?

$sql = mysql_query("ALTER TABLE `table_before` RENAME `table_after`");

This will rename a table called table_before to table_after.
If you want to rename more tables, make more querys 🙂 😉

[ir4z0r]

MY phpMA does, (2.2.6+)
maybe you should upgrade to a newer version
--> phpmyadmin.net