RE: [PHP] alter table name with php and mysql

2001-04-26 Thread Maxim Maletsky
it just as same as doing a query: $db->connect(); $db->query("ALTER TABLE table CHANGE field field ~ATTRIBUTES~"); well, that was with a DB abstraction layer. just use what you usually use to query your Db having your ALTER TABLE in the mysql_query. (no need to show the results up) Sincerely

Re: [PHP] alter table name with php and mysql

2001-04-26 Thread Andreas D. Landmark
At 26.04.2001 22:38, you wrote: >Hi, >check you've got a D/B connection, then use this, with the appropriate names >in the variables, or use the explicit table names if you wish. If an error >spews up, most likely the table name your trying to rename it to already >exists. Or the table you're tr

Re: [PHP] alter table name with php and mysql

2001-04-26 Thread Kevin A Williams
Hi, check you've got a D/B connection, then use this, with the appropriate names in the variables, or use the explicit table names if you wish. If an error spews up, most likely the table name your trying to rename it to already exists. $sql = "RENAME TABLE $present_table_name TO $new_table_name