473,385 Members | 1,888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Parsing XML in MYSQL using php, Date issue

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
2 1645
Dököll
2,364 Expert 2GB
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
2,057 Expert 2GB
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

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

Similar topics

3
by: AttilaTheChris | last post by:
I'm not sure if my last post went through (so my apologies if this is a repeat). I need to figure out how to separate a string that contains no delimters. In this case, a MySQL timestamp...
20
by: Sims | last post by:
Hi, I have a field in my DB that saves the date/time as a integer. I get the time on my server using the time() function. now, moving away from php and looking at (My)SQL only. If I use...
8
by: Gerrit Holl | last post by:
Posted with permission from the author. I have some comments on this PEP, see the (coming) followup to this message. PEP: 321 Title: Date/Time Parsing and Formatting Version: $Revision: 1.3 $...
0
by: Heikki Tuuri | last post by:
Hi! Many people have complained over years that Borland's dbExpress driver does not work with MySQL and transactions, because it disconnects from mysqld after each SQL statement. The postings...
2
by: Sam White | last post by:
I have set up a MySQL db on one server, IIS 6.0 on another. Using Frontpage I created some forms to input data. On a test page I made, I have 4 fields. First is the ID which is autonumber (I leave...
6
by: Piotr | last post by:
Hi, I have following problem: I use a form in excel to send data into mysql server, everything is ok unless I have to deal with decimals or data fields, this simple are not recognized. For...
5
by: jjeanj1 | last post by:
I am having issue using a user defined variable i an a mysql statement. here is the issue that i am facing: i have a variable called $date in php.This variable is assigned a valued from a dropdown...
1
by: paulq182 | last post by:
PLEASE HELP ME WITH MY CODE?? import java.sql.*; import java.io.*; class min_filmdb_rel_mysql { public static void main (String args ) throws SQLException, IOException {
6
Atli
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.