on the fly: use date_format function in select statement, format should be a string like %d%m%y not sure about it check on manual. hth adriano 2006/3/17, Tom Chubb <tomchubb@xxxxxxxxx>: > > 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']; > ?> > >
