insert not working

[tekram]

i have my products in a text file that i am trying to upload on to zen cart using php. i have thebelow line of cide to add to products_description table. data is an array that ontains the info i wnt to add. i am new tophp so forgive the stupid error i might be making.


$request1 = "INSERT INTO products_description (products_id, language_id, products_name) VALUES (200,1,$data[1])";
mysql_query($request1) or Die('didnot work');

[tekram]

clarification: i am using 200 for the product id just as a way to test if it gets added. which it has not...

[tekram]

well, it seems like the problem might be because the $data[1] has an apostrophe in it. anyway around this?

[TheOracle]

Which Zen-Cart version are you using ? I do not see any readings that contains, either, $request1 nor $data[1]. Did you installed a seperated MOD from the downloads contribution of this site ?

[tekram]

it is actually from code that i wrote.

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
$counter=40;
$file = fopen("comp.csv", "r");
$line=fgets($file);
$data=explode(',', $line);
echo $data[1];
$connection = mysql_connect("localhost", "root", "xxxxxx");
@mysql_select_db("gcatalog1") or die( "Unable to select database");
$request1 = "INSERT INTO products_description (products_id,products_name) VALUES (200,$data[1])";
mysql_query($request1) or Die(mysql_error());

?>

so when $data[1]=test i get the following out put:

testUnknown column 'test' in 'field list'


when $data[1]=Ma'alim al-Suluk li al-Mar'a al-Muslima output:

Ma'alim al-Suluk li al-Mar'a al-MuslimaYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''alim al-Suluk li al-Mar'a al-Muslima)' at line 1

not sure what to make of it?

[DrByte]

You need to "escape" those apostrophes.

Try adding an addslashes() around the variable containing your data with apostrophes.