insert not working

[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.

[tekram]

thanks very much. problem solved!!!

do you know how i can use a script like this to add things to the database that are not in english? ie, i have some proucts that u want to list in arabic. i have the names in a excel worksheet. once makin it into a flat list does not maintain the arabic.

thanks

[tekram]

i saved the file as a unicode text file but when i try tot extract the data it geives me soe funny outputs. for example the first line reads:
معالم السلوك للمرأة المسلمة

and then when i read ti with fget and echo it i get:
معالم السلوك للمرأة المسلمة ㄊ㈳愬⵬慑汵愠⵬慍爧景映⁩慆桤污䴭❡潲ⱦⰱ〲〰〬ㄮⰲ⸱ⰵ⸲㜵㐱㠲㜵ⰱ਍䐊灵楬慣整攠瑮祲✠〲㄰‧潦⁲敫⁹

the first bit of it is fine but what is after that is some extra stuff. where is that cooing form?

[tekram]

i think the prob is that the unicode i was using was not supported.

what i am trying to do is import a file of names of books into my database instead of entering them one by one. i am using book type by moku. it seems that when you enter books as type book the arabic is represented in the database as hex. whcih menas that i will have to enter them as hex in order for them to display correctly. does anyone know how i can save my data in hex foramt?

[tekram]

ok, i have solved the above problem but now have a different issue. i am able to add the books as needed however when i go to the front the books do show up when i click on show all prodcuts and show new products. they show up in but without any information. no titels, authors, weight etc. however, when i click on the specific category everything shows up just fine. i think i missed a table i am suppose to add to. i am using moku's produt type book.

the tabels i have added to are:
products
products_description
products_to_categories
product_book_extra
book_to_authors


what am i missing?