BoMan.de Posted November 16, 2005 Share Posted November 16, 2005 Hello, I've got the following problem with EP: Export works, import, too. But when there is a ' in products_description it won't. | DVD-BLDRND | dvd/blade_ | Blade Runn | Regional C | www.blader | Blade Runn | Regional C | www.blader | Blade Runn | Regional C | www.blader | 38.51 | 7.00 | | 2005-11-15 | 17 | Warner | DVD Filme | Science Fi | | | | | | Taxable Go | Active Updated1064 - 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 's Cut', products_description='Regional Code: 2 (Japan, UPDATE products_description SET products_name='Blade Runner - Director's Cut', products_description='Regional Code: 2 (Japan, Europe, Middle East, South Africa). Languages: English, Deutsch. Subtitles: English, Deutsch, Spanish. Audio: Dolby Surround 5.1. Picture Format: 16:9 Wide-Screen. Length: (approx) 112 minutes. Other: Interactive Menus, Chapter Selection, Subtitles (more languages).', products_url='www.bladerunner.com' WHERE products_id = '5' AND language_id = '1' [TEP STOP] The error is the not escaped 's in "Director's Cut". I tried to solve the problem by using mysql_real_escape_string() - but maybe at wrong place. PHP Version 4.3.10-15 MySQL 4.0.24 osC 2.2 MS2 build 051112 EP 2.76b1 Can anybody help me? Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.