Just a simple question..I cant work out

If I have a field in MySQL set as DATETIME so its set out like..
0000-00-00 00:00:00

When I query this in php how can I get this to be displayed like...

14-08-2004 15:10 ??

And also how can I order the results by date.. so the newest are shown first and vice-versa??

Thanks

-James

PHP Code:

$time = strtotime($mysqlRow['dateTime']);
$date = date("m-d-Y H:i", $time);
echo $date; 


that should work...

"SELECT * FROM yourTable ORDER BY yourDateTimeField DESC"
or
"SELECT * FROM yourTable ORDER BY yourDateTimeField (ASC)"

if you want to display your date/time different go to php.net and search for the date function...

hope this works for you..

Thanks

-James

Some other things to do with the date and time...

Basically I want to set it up so that it will display if a user is online or offline..

Say i have a field called 'activetime' which is updated everytime a user loads a page...

And Ive already selected all the stuff from the database and 'activetime' is refered to as $activetime

What would the code for the PHP be so that...

If $activetime is older than 5mins then do this....
otherwise do this....

??

Also what would the php be so it selects all the rows from the database where the 'activetime' field is no older than 5mins???

Thanks in advance

-James

PHP Code:

$active_time = time() - (60*5); // 60*5 = 5 mins in seconds :p
if(strtotime($your_variable['timedatestamp'])>=$active_time) { /* Active */ }
else { /* Not active */ } 


OK, as for this;

Also what would the php be so it selects all the rows from the database where the 'activetime' field is no older than 5mins???

Personally, where I'm working with a timestamp, I use a int of length 20 (Just in case my website lasts that long!), that way its easy to handle;

SELECT * FROM userinf WHERE last_thing>=$active_time

Thanks

Just one more thing I've thought of...

Would it be possible that if $activetime is today it will display..
Today at 00:23

and if its yesterday...

Yesterday at 00:23

Otherwise just display the date...

13-08-2004 at 00:23

Thanks

-James