piet Posted January 14, 2008 Share Posted January 14, 2008 ok, a bit more info maybe? my "event_date" field is formatted back to front in the db. "14.01.2008" instead of "2008.01.14" so the result of this script output is all scrabled. $do=mysql_query ("SELECT id,venue_name,event_date FROM calendar_events WHERE status='confirmed'and event_type='gig' ORDER by event_date DESC");v is there a way i can output this info corectly? this is a very large table so changing all the dates to the corect format is a big task, also i have other scripts reading from that table and changing the date format will mess with those scripts. Quote Link to comment Share on other sites More sharing options...
dooper3 Posted January 14, 2008 Share Posted January 14, 2008 Just replied to this on your original post Changing all the dates in the table is not a big task if you write a script to do it for you and the script would only need to be about 10 lines long max! Quote Link to comment Share on other sites More sharing options...
piet Posted January 14, 2008 Author Share Posted January 14, 2008 thanks dooper, and sorry for the double post, just thought i needed to clarify a bit as i didnt seem to get a resonce on the fist one. i will try your solution straight away Quote Link to comment Share on other sites More sharing options...
dooper3 Posted January 14, 2008 Share Posted January 14, 2008 No problem Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.