Hi How about doing this in the query string you send to mysql: DATE_FORMAT(fieldname, '%d %m %y') this way you wont have to mess around with the array stuff. for more info look here http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html Regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services "Tom Chubb" <tomchubb@xxxxxxxxx> wrote: > Please can you help me. I've created a page where problems are posted into a > database and I am using the datetime format in MySQL and trying to find the > best way to display it in the 17/03/06 format. > I've found a way of doing it (so you don't think I haven't googled, RTFM) > but don't think it's the best way. > Any help would be appreciated. > > (Current Code:) > > <?php > $datestr = $row_rsSnags['date']; > $arr1 = str_split($datestr, 2); > echo $arr1 [2]; > echo "/"; > echo $arr1 [1]; > echo "/"; > echo $arr1 [0]; > // echo $row_rsSnags['date']; > ?> > Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
