Date formatting

hi all =)

Im trying to format a date from a mysql field set as timestamp(14)..
or datetime if its easier/better

at the mo ive got:

$get = mysql_query("SELECT * FROM table ORDER BY id ASC") ;

then further down i have ...

while($row = mysql_fetch_row($get))
{
...
(print "row[X]"; for e.g.)
}

im trying to get it to display as '18:04 5/5/02' for example,
but nothing i try seems to work =/

Lookup the strftime() function...

If you're trying to format a unix timestamp into something someone can understand then you would do something like this...

$time = time(); // unix timestamp

strftime("%H:%M on %d/%m/%y", $time); //to the specification you provided in your post.

Hope this works for you. There are many other ways of formatting the time...

Regards, Stezz.

)

Thanks =) ill check that out

after a few days of endless tries of all sorts I ended up just using an ereg replace to move bits around etc..

other things that i had used b4 dont seem to work now.. i dont know if that was due to php4 upgrades or anything, but anyway..
Thanks