插入将数组数据提取到新数据库

我正在尝试从MYSQL中选择数据行，并将其作为数组行插入到带有一些附加数据的新数据库中。请帮忙，此脚本不起作用：

// there is some script and here goes fetching-inserting script:
<?php
include ('connection.php');
$query="SELECT * from savatcha where mem_id='$mem_id' ORDER BY nomination ASC";
$result=mysql_query($query);
$num=mysql_numrows($result); 
mysql_close();
$i=0;
$grand_total=0;
while ($i < $num) 
{
  $savatcha_id=mysql_result($result, $i, "savatcha_id");
  $s_mem_id=mysql_result($result, $i, "s_mem_id");
  $mem_id=mysql_result($result, $i, "mem_id");
  $tovar_id=mysql_result($result, $i, "tovar_id");
  $nomination=mysql_result($result, $i, "nomination");
  $price=mysql_result($result,$i,"price");
  $quantity=mysql_result($result,$i,"quantity");
  $total_row=$price * $quantity;
  $grand_total += $total_row;
?>
<?php
  include ('order_connection.php');
  mysql_query("INSERT INTO order_list(order_id, s_mem_id, mem_id, firm_name, grand_total, order_method, order_date)VALUES('$order_id', '$s_mem_id', '$mem_id', '$firm_name', '$grand_total', 'Bank hisob raqami orqali', '$date')");
  mysql_close();
?>
<?php
  ++$i;
}
?>