PDA

View Full Version : Importing XML into phpMyAdmin for MySQL



JShor
05-17-2007, 02:20 PM
Hi, I get this error when importing an XML sheet into phpMyAdmin:

#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
'<?xml version="1.0" encoding="utf8" ?>'

I checked the MySQL database manual, but no luck in changing anyting. This makes no sense since I exported it from phpMyAdmin into XML format, and re-uploaded it without making changes to it. I selected the character encoding to UTF8 when uploading in the form drop down menu, but still no luck in uploading. Can anyone tell me what I am doing wrong?:confused: :confused: Thanks if you can :)