WOW!! Thanks for all the help guys!! And Instruct ICC.. you're solution for pulling the events did work.. but.. it turns out that the solution was actually much simpler than I thought: The old mysql database (once again, not sure what version) stored the date as YYYYMMDDHHMMSS. The new database stores the date as YYYY-MM-DD HH:MM:SS. All I had to do was adjust my code to pull only the values and none of the delimeters (ie. "-", " ", and ":"). DUH!!!!!!! But once again, thanks you guys for all the help!!!! rDubya On 9/7/07, Instruct ICC <instructicc@xxxxxxxxxxx> wrote: > >From: "Instruct ICC" <instructicc@xxxxxxxxxxx> > >And while not trusting your indexing, rewrite short_date as: > My short_date rewrite was also wrong. So it looks like you will have to > learn those offsets for this function if you do it on the PHP side. But you > could also do it on the MySQL side. > > _________________________________________________________________ > Get a FREE small business Web site and more from Microsoft(r) Office Live! > http://clk.atdmt.com/MRT/go/aub0930003811mrt/direct/01/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
