> Anyone have a link (or the code) to copy the structure of a blank
> to a new table using mysql?

function change_table_name($old_name, $new_name)
  $result = mysql_query("show create table $old_name");
  $create = mysql_result($result,0,1);

  str_replace("TABLE `$old_name`","TABLE `$new_name`",$create);

  $result = mysql_query($create);


Untested, add in some error checking and validate the $old and $new
names, and adapt to your needs...

---John Holmes...

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to