Re: Dates in PHP

["whatalotofrubbish" <webforumsuser@xxxxxxxxxxxxxx>]

This worked fine - once I had realised that it created another column with the 
same name. 

 Changing the code to read

 SELECT thisCol, thatCol, anotherCol,
 DATE_FORMAT(photodate, '%e-%c-%Y') AS newphotodate
 FROM myTable

 All that needed doing after that was to drop the original photodate column and 
rename newphotodate to photodate, and create a new view.

 When I write the new input routines, I must remember to format the date before 
it gets stored.
 Rubbish in - rubbish out.

 This is part of the job of converting an existing site that uses asp and 
excell to php and mysql. Both of which I have not used before.

 The learning curve is steep!

 Thanks a lot.
 Howard