I am inserting data into a mysql database. I have done it many times. For some reason when I do it with the new site I am getting an error in my insert query....
Array ( [0] => 201786 [1] => 681-18-AntiqueWhite [2] => 18 Saddle Seat Stool - Antique White [3] => Supplier Alder|Home and Garden|Furniture [4] => http://www.companysite.com/site/images.products/28/683-682-681.jpg [5] => Carolina Cottage [6] => 18 Saddle Seat Stool
Antique White
17.5W X 9D X 18H
Made of rubber wood that comes from China and Malaysia [7] => [8] => 12 [9] => 16.375 x 19.375 x 19.75 [10] => N [11] => N [12] => N [13] => 18 Saddle Seat Stool - Antique White [14] => 0 [15] => 45.58 [16] => 86 [17] => 15 [18] => [19] => 20.82 [20] => 2 )
Data Insert Error: 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 ') VALUES ('201786', '681-18-AntiqueWhite', '18 Saddle Seat Stool
here is the code I am using
$filename = $_FILES['viartfile']['name'];
//echo "<br /> $filename<br /><br />";
$uploaddir = 'tab/';
$uploadfile = $uploaddir . $filename;
if (move_uploaded_file($_FILES['viartfile']['tmp_name'], $uploadfile)){
//Read File
$fcontents = file($uploadfile);
for($i=0; $i<sizeof($fcontents); $i++) {
$line = trim($fcontents[$i]);
$data = explode("\t", $line);
//print_r ($data);
$data = str_replace("\"", "", $data);
// Empty viart import table
$empty_table_sql = "TRUNCATE TABLE viart_import";
$r2 = mysql_query($empty_table_sql, $dbConn)or die("Empty Table Error: " .mysql_error());
print_r ($data);
$product_id = $data[0];
$sku = $data[1];
$title = $data[2];
$categories = $data[3];
$image_url = $data[4];
$brand = $data[5];
$description = $data[6];
$details = $data[7];
$weight = $data[8];
$dimensions = $data[9];
$going = $data[10];
$refurb = $data[11];
$freight = $data[12];
$item_name = $data[13];
$map = $data[14];
$price = $data[15];
$msrp = $data[16];
$qty_avail = $data[17];
$est_avail = $data[18];
$expected_shipping_cost = $data[19];
$expected_drop_ship_fee = $data[20];
$data_import_sql = "INSERT IGNORE INTO viart_import (`PRODUCT_ID`,`SKU`,`TITLE`,`CATEGORIES`,`IMAGE_URL`,`BRAND`,`DESCRIPTION`,`DETAILS`,`WEIGHT`,`DIMENSIONS`,`GOING`,`REFURB`,`FREIGHT`,`ITEM_NAME`,`MAP`,`PRICE`,`MSRP`,`QTY_AVAIL`,`EST_AVAIL`,`EXPECTED_SHIPPING_COST`,`EXPECTED_DROP_SHIP_FEE`,) VALUES ('$product_id', '$sku', '$title', '$categories', '$image_url', '$brand', '$description', '$details', '$weight', '$dimensions', '$going', '$refurb', '$freight', '$item_name', '$map', '$price', '$msrp', '$qty_avail', '$est_avail', '$expected_shipping_cost', '$expected_drop_ship_fee')";
$data_import_results = mysql_query($data_import_sql, $dbConn)or die("<br>Data Insert Error: ". mysql_error());
}
query fails at the same point in the query. I thought it might be the database table setup...
here is the sql...
/
MySQL Backup
Source Host: localhost
Source Server Version: 4.1.19-community-nt
Source Database: viart
Date: 2006/06/07 14:18:52
/
use viart;
SET FOREIGN_KEY_CHECKS=0;
#----------------------------
Table structure for viart_import
#----------------------------
CREATE TABLE viart_import (
PRODUCT_ID varchar(255) NOT NULL default '',
SKU varchar(255) NOT NULL default '',
TITLE longtext NOT NULL,
CATEGORIES longtext,
IMAGE_URL varchar(255) NOT NULL default '',
BRAND varchar(255) NOT NULL default '',
DESCRIPTION varchar(255) NOT NULL default '',
DETAILS varchar(255) NOT NULL default '',
WEIGHT text NOT NULL,
DIMENSIONS text NOT NULL,
GOING text NOT NULL,
REFURB text NOT NULL,
FREIGHT text NOT NULL,
ITEM_NAME blob NOT NULL,
MAP text NOT NULL,
PRICE text NOT NULL,
MSRP text NOT NULL,
QTY_AVAIL text NOT NULL,
EST_AVAIL text NOT NULL,
EXPECTED_SHIPPING_COST text NOT NULL,
EXPECTED_DROP_SHIP_FEE text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
No records for table viart_import
#----------------------------
any help would be appreciated
Thanks
