[ Marko Vegas @ 25.11.2007. 19:02 ] @
Imam mySQL bazu osCommerce za knjizaru online, koju kada punim iznutra softverom osCommerce sve je u redu.
Takodje, sve je u redu kada sa programom php punim slog tabele koji nema slozen primarni kljuc.
Medjutim, kada slogove tabele koja ima slozen primarni kljuc, gde je privi deo kljuca auto_increment, a drugi ogranicen na 4 broja, recimo u slucaju tabele "products_description" ciji se primarni kljuc sastoji od dva dela: products_id - koji je auto_increment, i languages_id - koji uzima vrednosti 1 - 4, server mi izbaci gresku:
"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 'preko vjecnosti, Ricard Bah: Most preko vjecnosti, Mono i Manja"

Program (php) pada na sledecoj liniji

Code:

mysql_query("INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) 
                            VALUES (null, $Jezik, $Naziv, $Opis, Null, '0') ") 
            or die(mysql_error());  


Kako da ovo resim?
[ misk0 @ 25.11.2007. 19:10 ] @
A da posaljes jedan DESC PRODUCTS_DESCRIPTION ?
[ Marko Vegas @ 25.11.2007. 21:56 ] @
Evo DESC-a...

SQL result
Host: localhost:3306
Database: auctionc_p_os1
Generation Time: Nov 25, 2007 at 01:23 PM
Generated by: phpMyAdmin 2.10.2 / MySQL 4.0.16
SQL query: DESC products_description;
Rows: 6


Field Type Null Key Default Extra
products_id int(11) - PRI NULL auto_increment
language_id int(11) - PRI 1
products_name varchar(64) - MUL -
products_description text YES - NULL
products_url varchar(255) YES - NULL
products_viewed int(5) YES - 0
[ chachka @ 25.11.2007. 23:18 ] @
Kvotuj varchar (string) vrednosti