error in your SQL syntax

[pantufas_online]

hello!

 

i've installed an add on to import excel, and it gives me this error when i try to import it, before i corrected many other php mistakes...

 

File uploaded (temp filename: C:\Program Files\EasyPHP-5.3.6.0\tmp\php45AD.tmp)
1064 - 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 '0')' at line 1

insert into manufacturers(manufacturers_name,manufacturers_image,date_added) values('???ÿ}-}6ÿÿ_¬ _-}x}1ÿÿÌÿ_¬ _-²²²ÿ¥¥¥ÿ#0²²²ÿ???ÿ-;','²²²ÿ???ÿ?\','0')

[TEP STOP]

 

if anyone knows something, please tell me. i dont understand anything of sql... :(

 

thanks

[Xpajun]

What text program did you use to update the php files?

 

Looks like you may have used something like Word which will produce non-standard characters.

 

Use a plain text editor.

[MrPhil]

The immediate problem is here:

,'²²²ÿ???ÿ?\','0')

See the \ ? That's escaping the ' right after it, so the second string is ²²²ÿ???ÿ?',. Then PHP encounters 0' and doesn't know what to do with it. The 64-dollar question is "Why is there a \ in there?" Was there supposed to be another character following it that was being escaped, before the closing quote?

 

Whatever did you use to create this data? Is it a cut and paste from something on your PC? It looks like there may also be a character encoding issue, at least a non-UTF-8 system on your end and a UTF-8 forum here.

[pantufas_online]

thanks :)