여분필드 wr_39까지 사용중인데 explode 로 나눠서 특정 필드에 넣으려고 하는데 너무 어렵네요.
A사이트 DB > B사이트 DB 로 옮기면서 변환하려고 합니다.

wr_1 ~wr_39 까지 내용을
wr_11, wr_12에 각각 explode로 "|" 로 구분하여 넣으려고 하는데요.
아무리 해도 여기까지 밖에는 안되네요.

에러 메세지는 안나오는데 insert가 안됩니다.

조언좀 부탁드립니다.

소스내용

<?php

//A사이트 시작
include "./lib/common.lib.php";

$mysql_host = 'host';
$mysql_user = 'id';
$mysql_password = 'pw';
$mysql_db = 'db';

$connect = mysql_connect($mysql_host, $mysql_user, $mysql_password, $mysql_db);
mysql_select_db($mysql_db);

$table = "g4_write_t01";
$sql = "select * from '$table' where '$table'";
$result = sql_query($sql);

for($i = 0; $row = sql_fetch_array($result); $i++)
{


// 추가된 내용
$n0  = $wr_10;

$m0  = $wr_6;
$m1  = $wr_7;
$m2  = $wr_1;
$m3  = $wr_2;
$m6  = $wr_8;
$m7  = $wr_9;
$m8  = $wr_3;
$m9  = $wr_4;
$m12  = $wr_14;
$m13  = $wr_13;
$m14  = $wr_5;
$m34  = $wr_11;
$m5  = $wr_12;
$m22  = $wr_16;
$m23  = $wr_15;
$m24  = $wr_18;
$m25  = $wr_17;
$m26  = $wr_20;
$m27  = $wr_19;
$m28  = $wr_22;
$m29  = $wr_21;
$m30  = $wr_23;
$m31  = $wr_24;
$m39  = $wr_25;
$m32  = $wr_28;
$m33  = $wr_27;
$m16  = $wr_26;
$m18  = $wr_29;
$m19  = $wr_30;
$lm40  = $wr_37;
$lm41  = $wr_38;
$m42  = $wr_39;





$wr_11=$n0.'|'.$n1.'|'.$n2;
$wr_12=$m0.'|'.$m1.'|'.$m2.'|'.$m3.'|'.$m4.'|'.$m5.'|'.$m6.'|'.$m7.'|'.$m8.'|'.$m9.'|'.$m10.'|'.$m11.'|'.$m12.'|'.$m13.'|'.$m14.'|'.$m15.'|'.$m16.'|'.$m17.'|'.$m18.'|'.$m19.'|'.$m20.'|'.$m21.'|'.$m22.'|'.$m23.'|'.$m24.'|'.$m25.'|'.$m26.'|'.$m27.'|'.$m28.'|'.$m29.'|'.$m30.'|'.$m31.'|'.$m32.'|'.$m33.'|'.$m34.'|'.$m35.'|'.$m36.'|'.$m37.'|'.$m38.'|'.$m39.'|'.$m40.'|'.$m41.'|'.$m42;

}




//B사이트 시작
$dbhost= "host";
$dbid  = "id";
$dbpw  = "pw";
$db    = "db";
$DBConn = mysql_connect($dbhost,$dbid,$dbpw) or die(errMsg('1','','history.back()'));
mysql_select_db("$db",$DBConn);



for($i = 0; $row = sql_fetch_array($result); $i++)
{

// 게시물을 등록한다
$query = "INSERT INTO g4_write_b01 SET

wr_option = '$html,$secret,$mail',
wr_num = '$num',
wr_reply = '$reply',
wr_subject = '$title',
wr_content = '$content',
wr_link1 = '$row[link1]',
wr_link2 = '$row[link2]',
wr_hit = '$row[hit]',
wr_good = '',
mb_id = '$mb_id',
wr_password = '$row[password]',
wr_name = '$name',
wr_email = '$row[e_mail]',
wr_homepage = '$row[home]',
wr_datetime = '$reg_date',
wr_ip = '$row[ip]',
wr_is_comment = 0,
wr_comment = '$row[total_comment]',
wr_1 = '',
wr_2 = '',
wr_3 = '',
wr_4 = '',
wr_5 = '',
wr_6 = '',
wr_7 = '',
wr_8 = '',
wr_9 = '',
wr_10 = '',
wr_11 = '',
wr_12 = '',
wr_13 = '',
wr_14 = '',
wr_15 = '',
wr_16 = '',
wr_17 = '',
wr_18 = '',
wr_19 = '',
wr_20 = ''";

sql_query($query);
}


?>



조언좀 부탁드립니다.