Order problems

zcollvee

I have my forums list from the date and time updated
kinda like
Day Month Year Hour Minute Second
30 04 08 24 04 06
But today is
Day Month Year Hour Minute Second
01 05 08 03 04 01
and none of the new posts are showing up in the side bar....
I understand this problem but don't know how to solve it.
Please help

phpvn_org

You should use date/time function in Unix timestamp . It'll convert date/time into an integer value, so you can do more than you want.
For example,

<?php
$nextWeek = time() + (7 24 60 * 60);
// 7 days; 24 hours; 60 mins; 60secs
echo 'Now: '. date('Y-m-d') ."\n";
echo 'Next Week: '. date('Y-m-d', $nextWeek) ."\n";
// or using strtotime():
echo 'Next Week: '. date('Y-m-d', strtotime('+1 week')) ."\n";
?>
See PHP Manual for more details.

Roger_Ramjet

If your column type is DATETIME then mysql will order correctly, so to display the 10 most recent posts your would

SELECT * FROM posts ORDER BY dateupdated DESC LIMIT 10

Just forget about outdated things like UNIX Timestamp, not required in any dialect of SQL as they all have fully functional date functions to add, subtract, compare, order by and format native date data types.

zcollvee

the problem is dateupdated is not DATE.