By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,957 Members | 1,218 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,957 IT Pros & Developers. It's quick & easy.

Parsing XML in MYSQL using php, Date issue

P: 1
Hi, I am hoping someone can point me in the right direction as I have been trying to fix this issue for a good while now.

I am trying to take information out of a xml file using php and parsing it into a MYSQL database but when I do this it takes all the information correctly out of the xml file and puts it into the database apart from the date. The date for each article is the same as the first one for example

Article 1 (Created 30/5/2007) date = 04/05/2007

Article 1 (Created 28/5/2007) date = 04/05/2007

Article 1 (Created 20/5/2007) date = 04/05/2007

Article 1 (Created 13/5/2007) date = 04/05/2007

Article 1 (Created 04/5/2007) date = 04/05/2007

for some reason it isnt keeping each articles date. Can anyone help?
Aug 29 '07 #1
Share this Question
Share on Google+
2 Replies


Dököll
Expert 100+
P: 2,364
Article 1 (Created 13/5/2007) date = 04/05/2007

Article 1 (Created 04/5/2007) date = 04/05/2007

for some reason it isnt keeping each articles date. Can anyone help?
Greetings!

I am adding this to PHP for now, please also search through the PHP forum beforehand, something may have been posted, similarly in reponse.

Good luck with the project!
Aug 30 '07 #2

jkmyoung
Expert 100+
P: 2,057
Are you sure you're not confusing the database's internal created column with a created column in your own schema?
Aug 30 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.