hey there I have a script which runs daily to update my DB with data(online games) It works like this, opens an XML feed from my provider, parses it, and runs individual mysql_querys to insert rows into my games table The problem is that only around half of these games get put into the database and these missing items are not in a particular order. I actually cannot find any kind of pattern or similarity between the ones that do not end up in the DB as opposed to the ones that do. I hope this is enough information, if not please inform me. Has anyone had something similar?
Perhaps its your different database fields length, like maybe games with a long description are blocked or a long title. It could be anything, maybe the game ids are clashing with others you have listed already, who knows. Could you show us the page where the data comes from and of course your page so we can compare the differences ?
Yes, we need the to see what your describing. Its probably some data that your picking up thats messing with your queries. Try using escape characters in your query string.
Can you make your script log the queries it's using? Then you can find the queries for the items that didn't get inserted and see if anything is wrong with them.
It would also be helpful to see one of the xml files and show what records did not get entered. That with the table structure (field type, size, etc...) would be more helpful in determining what might cause the error(s).
sure! sorry guys i was on vacation my page is http://onlinegalore.com here is the XML file it is using: XML for example you may see on my front page that my database only contains 2 mahjong games The xml file however contains more than that once again sorry for late late response looking forward to yours