simple datetime question

[skinny_monkey]

when i retreive a datetime field from mysql, how can i display the value in php so that it goes on one line?

At the moment it looks like:
2003-08-27
09:08:49

on two seperate lines, and its making my tables look unnecessarily bulky.

cheers

[php2learn]

what u use to retrieve datetiem fields

do u use functions seperate for each one are a single function for both time and date

[skinny_monkey]

i'm not sure i follow:

to retreive the data i use:

$result = mysql_query("select * from user_db where user = '$UserName' order by index);

Then to display the date field in particular:

echo $row["datelastupdated"];

[philhale]

This is the function I enjoy the most:

echo date("d-M-y",strtotime($datelastupdated));

This returns a date string as the example:

27-Aug-03

Change the format string (first arg) to whatever format that you prefer. Look up the function date().

Good luck!

Phil.

[php2learn]

try this function

strftime("%Hh %M %A%d %b",time( ))
get time n date string in single line