SQL Error

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
btrade
User
Posts: 357

SQL Error

Post by btrade »

Hello,

I have an error after this query

ew_Execute("INSERT INTO text_edit (chars, chars_space, words, pages, pages_space, text, profiles_id, cloud_id, from_name, date, language, docs) VSLUES ('".$rsold['chars']."', '".$rsold['chars_space']."', '".$rsold['words']."', '".$rsold['pages']."', '".$rsold['pages_space']."', '".$rsold['text']."', '".$rsold['profiles_id']."', '".$rsold['cloud_id']."', '".$rsold['from_name']."', '".$rsold['date']."', '".$rsold['language']."', '".$rsold['docs']."') ", DB_TRANSLATOR);

Failed to execute SQL: INSERT INTO text_edit (chars, chars_space, words, pages, pages_space, text, profiles_id, cloud_id, from_name, date, language, docs) VSLUES ('17', '24', '5', '0.01', '0', '
rrrrrr / / text?
', '49', '10', '43', '2017-12-12 14:42:07', 'afa', '0') . 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 'VSLUES ('17', '24', '5', '0.01', '0', '
rrrrrr / / text?
' at line 1 (1064)

I think this is due to special characters. What function in PHPMaker can I use to process characters - in $rsold['text']?


uwiii
User
Posts: 12

Post by uwiii »

Try VALUES not VSLUES


btrade
User
Posts: 357

Post by btrade »

wow. yes ))
thsnks you


Post Reply