I need to convert a UNIX timestamp date to mySQL format and then write that date to a mySQL table in two different fields, date and time. I've looked around and can't find any examples similar to what I want to do. I have no problem figuring out how to use that date(parse, timestamp) function, but am struggling with how to proceed from there.
What I am doing is converting the data from that convaluted Matt Kruse Perl Calendar Script to use with the Codewalker PHP Calendar. Kruse uses lots of UNIX time stamps that have to be converted, plus, he used two tab delimited flat files where he could have used just one. There will be lost of hoops to jump through to load the data into the mySQL table in the proper format, but not as much as re-entering over 500 events 🙂
I probably would have just left it alone until the end of the school year, but for some unknown reason, the admin portion just up and quit working last week. I can't figure out why it isn't working and neither can the server admin, so I'm giving up and moving to a PHP calendar now instead of over the summer.
