Re: php5, MySQL date problem
Ok have got this far :thumb:
SELECT * FROM table_name ORDER BY date_ent DESC LIMIT 10
NOW() seems the best bet for getting the current date time into the record :eek2:
Re: php5, MySQL date problem
you can use the DATETIME data type. the format is YYYY-MM-DD HH:MM:SS, where HH is 0-23. I don't know what else you're asking for, since you've already used ORDER BY.
NOW() is the function to use if you want a DATETIME, whereas CURDATE() would be used for just a DATE, and CURTIME() would be used for just a TIME.
Re: php5, MySQL date problem
Should have an actual question by tomorrow when I try all this new found goodness out :)