[SQL][PHP]syntax error, unexpected T_STRING Opcje

[ilidir]

witam mam mały problem z tym komunikatem i nie wiem jak go wyelyminować oto kod zapytania SQL

[SQL] pobierz, plaintext 
$artykuladd = mysql_query("INSERT INTO ofria_content(id, asset_id, title, alias, title_alias, introtext, fulltext, state, sectionid, mask, catid, created, created_by, 
created_by_alias, modified, modified_by, checked_out, checked_out_time, publish_up, publish_down, images, urls, attribs, version, parentid, ordering, metakey, metadesc,
 access, hits, metadata, featured, language, xreference) VALUES (NULL, '185', '$sama_nazwa_komisji', '$komisja_string', '', '<p>{jumi [../$miasto_string
/$sama_nazwa_komisji/index_skrypt_eodtest.php]}</p>', '', '1', '0', '0', '81', '2014-11-10 00:00:00', '600', '', '0000-00-00 00:00:00', '0', '0', '0000-00-00 00:00:00', 
'0000-00-00 00:00:00', '0000-00-00 00:00:00', 
'{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}',
 '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","sh
ow_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","SHOW
_hits":"","show_noauth":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_ima
ges_frontend":""}', '5', '0', '0', '', '', '0', '0', '{"robots":"","author":"","rights":"","xreference":""}', '0', '*', '')");
[SQL] pobierz, plaintext 

[Turson]

Podpowiedź. Nie:

[PHP] pobierz, plaintext 
$string = "ala "ma" kota";
[PHP] pobierz, plaintext 

a

[PHP] pobierz, plaintext 
$string = "ala \"ma\" kota";
[PHP] pobierz, plaintext 

Ten post edytował Turson 5.11.2014, 13:31:25

[ilidir]

no super a może mi kolega naświetlić co robi ten \ ? że teraz działa

[Turson]

[PHP] pobierz, plaintext 
    $string = "ala "ma" kota";
[PHP] pobierz, plaintext 

W tej sytuacji łańcuch jest zamykany po ala, aby uniknąć zamknięcia dajemy backslash.
http://php.net/manual/en/language.types.st...g.syntax.double