Fra en table til en anden table?

Går udfra, at de to tabeller har en identisk struktur!?
-----------------------------------------
$sql = "SELECT * FROM users1 where id=$userid";
$result = mysql_query($sql);
if($row = mysql_fetch_array($result))
{
    $sql = "INSERT INTO users2 ";
    foreach($row as $key => $value)
    {
        $sql1[] .= "$key";
        $sql2[] .= "'$value'"
    }
    $sql = $sql."(".implode(",",$sql1).")" VALUES (".implode(",",$sql2).")";
    mysql_query($sql);
}

Mange tak, men jeg har dog lidt svært med at få det til at virke.
Her er scriptet som jeg bruger til at slette en, så skulle det vel også være til at flytte personen.

<?php
include "variables.php";
?>
<?php

  $date = date("M d, Y");
if ($submit) {
$db = mysql_connect($databaseserver, $databaseuser, $databasepass);
        mysql_select_db($databasename,$db);
  $sql = "DELETE FROM $playerstable WHERE name='$deletename'";
  $result = mysql_query($sql);
  echo "Thank you! Information entered.<br><a href='$directory/Admin/index.php'>Return to admin panel</a>";
} else{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<center>
    <table border="0" cellpadding="0" width="100%">
      <tr>
        <td width="12%">
  Name:</td>
        <td width="88%"><select size="1" name="deletename">
<?php
    $db = mysql_connect($databaseserver, $databaseuser, $databasepass);
        mysql_select_db($databasename,$db);
$sortby = "name ASC";
$sql="SELECT * FROM $playerstable ORDER BY $sortby";
$result=mysql_query($sql,$db);
$num = mysql_num_rows($result);
$cur = 1;
echo "<ol>";
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$name = $row["name"];
?>
<option><?php echo "$name" ?></option>
<?php
$cur++;
}
echo "</ol>";
?>
</select></td>
      </tr>
    </table>
  </center>
<p>  <input type="Submit" name="submit" value="Submit">
  </form>
<?php
}
?>

Try this... ellers må du komme med nogle informationer om tabellernes strukturer og navne!?
$sql = "SELECT * FROM users1 where id=$userid";
$result = mysql_query($sql);
if($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    $sql = "INSERT INTO users2 ";
    foreach($row as $key => $value)
    {
        $sql1[] .= "$key";
        $sql2[] .= "'$value'"
    }
    $sql = $sql."(".implode(",",$sql1).")" VALUES (".implode(",",$sql2).")";
    mysql_query($sql);
}