Actually I don't want timestamp becauase the format is different to MySQL 4.1 and higher, I may be wrong but I thought timestamp updates each time a record is modified and I only want a creation date ...
I'm trying to use datetime with a MySQL 3.23 DB to record the date that each record is created, I've tried creating a table using
`date` datetime NOT NULL default 'NOW()',
`date` datetime NOT NULL default 'CURRENT_DATE',
`date` datetime NOT NULL default 'CURRENT_TIMESTAMP',
Anyone an idea how...
I'll post a snippet from the XML file tomorrow, don't have it handy at the moment, I may just pay a good PHP developer to do this for me yet, it's nice to learn something new but I don't have think I have the time at the moment ....
Hopefully one of the forum administrators will have pity on me and change the 'dada' typo !!
I'm not sure myself what information is going to be used from the XML file, I have a hunch it will be required to take only some of the data from the XML file.
Existing PHP backend has standard DB...
I want to import XML data into a MySQL database, preferable using a PHP backend. Has anyone experience of doing this and can give me a few pointers please ..
Thanks.........
Thanks, I think that's an old tech note though referring to DReamweaver MX (v6), since Dreamweaver MX 2004 now has SFTP support, I just wondered if anyone can clarify if the MySQL database connection (if it's a remote connection) is secure ?
Thanks........
Does anyone know how the databse information is transfered from a remnote MySQL database to the development machine in Dreamweaver MX 2004 and how secure it is? Aside from the SFTP support for file transfer I'm not sure that security extends fully to the movement of database information ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.