사용 환경
OS : windows2003 서버
mysql 버전  5.0.51a
PHP Version 5.2.9-2
사이트 : http://mynetcom.co.kr
실행 테스트는 http://mynetcom.co.kr/musicinsert.php
오류 내용
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , , , , ' at line 52

일괄 입력 파일 소스

<?
/*
CSV import script for PHP4/5, Willem Spruijt, 2005
Assuming that your ip-to-country table is created using this query:

*/

mysql_connect("localhost", "디비아이디", "디비패스워드");
mysql_select_db("love");
mysql_query("DELETE FROM g4_write_409") or die (mysql_error());



/*
Defines
*/
define("SOURCE_FILENAME", "g23.csv"); //입력 할 파일

define("SEPERATOR_COL", ",");

define("SEPERATOR_ROW", 'n');

/*
Open database connexion & cleanup
*/

/*
Open file for reading
*/
$fhFile    = fopen(SOURCE_FILENAME, "r") or die ("Error opening ".SOURCE_FILENAME);
$sData      = fread($fhFile, filesize(SOURCE_FILENAME));

$aData      = explode(SEPERATOR_ROW, $sData);

foreach($aData as $sRow) {
    $aRow = explode(SEPERATOR_COL, $sRow);
    /* Prepare values for query */
    foreach($aRow as $sKey => $sValue) {
        $sValue        = str_replace('"', "", $sValue);
        $sValue        = addslashes($sValue);
        $aRow[$sKey]    = "'".$sValue."'";
    }
    list($swr_id, $swr_num, $swr_reply, $swr_parent, $swr_is_comment, $swr_comment, $swr_comment_reply, $sca_name, $swr_option, $swr_subject, $swr_content, $swr_link1, $swr_link2, $swr_link1_hit, $swr_link2_hit, $swr_trackback, $swr_hit, $swr_good, $swr_nogood, $smb_id, $swr_password, $swr_name, $swr_email, $swr_homepage, $swr_datetime, $swr_last, $swr_ip, $swr_1, $swr_2, $swr_3, $swr_4, $swr_5, $swr_6, $swr_7, $swr_8, $swr_9, $swr_10) = $aRow;
    $sQuery = "INSERT INTO g4_write_409
                                (wr_id,
wr_num,
wr_reply,
    wr_parent,
wr_is_comment,
wr_comment,
wr_comment_reply,
ca_name,
wr_option,
wr_subject,
wr_content,
wr_link1,
wr_link2,
wr_link1_hit,
wr_link2_hit,
wr_trackback,
wr_hit,
wr_good,
wr_nogood,
mb_id,
wr_password,
wr_name,
wr_email,
wr_homepage,
wr_datetime,
wr_last,
wr_ip,
wr_1,
wr_2,
wr_3,
wr_4,
wr_5,
wr_6,
wr_7,
                                wr_8,
wr_9,
wr_10)
                            VALUES
                                (".$swr_id.",
".$swr_num.",
".$swr_reply.",
".$swr_parent.",
".$swr_is_comment.",
".$swr_comment.",
".$swr_comment_reply.",
".$sca_name.",
".$swr_option.",
".$swr_subject.",
".$swr_content.",
".$swr_link1.",
".$swr_link2.",
".$swr_link1_hit.",
".$swr_link2_hit.",
".$swr_trackback.",
".$swr_hit.",
".$swr_good.",
".$swr_nogood.",
".$smb_id.",
".$swr_password.",
".$swr_name.",
".$swr_email.",
".$swr_homepage.",
".$swr_datetime.",
".$swr_last.",
".$swr_ip.",
".$swr_1.",
".$swr_2.",
".$swr_3.",
".$swr_4.",
".$swr_5.",
".$swr_6.",
".$swr_7.",
".$swr_8.",
".$swr_9.",
".$swr_10."
                            );";
   
    mysql_query($sQuery) or die (mysql_error());
}

?>