$query = "ALTER TABLE `foo` RENAME `bar`"; $result = mysql_query($query);
Obviously you need to be connected to the database first, and should also do error checking after to make sure the table was in fact renamed. p.s. I use phpMyAdmin to find out how to do stuff I don't yet know. Good Software. -Dash -----Original Message----- From: Rodrigo San Martin [mailto:rodrigo@;stud.ntnu.no] Sent: Tuesday, November 12, 2002 12:33 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] update tablename Hi. I want to change a tablename in my database. How do i do that? I want to do it from a webpage so i need to use php. ------------------------------------------ Rodrigo San Martin Institutt for datateknologi og informatikk http://www.idi.ntnu.no/~rodrigo -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
