getting date and time into mysql

Anonymouz

Hi Guyz,

when building my own newspage, i want the lastest news inserted in the database to be the first one on my page. This i want to do with the following line

select * from table where date=(select max(date) from table) and
time=(select max(time) from table)

How do i get these date and time values in my database and attached to my databaseentries?

If Anyone has a clue....??

Please Help Me

vasah20

Sorry bro, you can't. MySQL doesn't support subqueries yet.

Your best bet would be to issue separate queries, and use the results from each.

using PEAR...

//assumes connections have been made and the db object is in $db

$my_date = $db->getOne("select max(date) from table");
$my_time = $db->getOne("select max(time) from table");
$result = $db->getAll("select * from table where date=$my_date and time = $my_time);

Make sure you check my syntax though, I'm not 100% positive I'm calling the PEAR functions correctly (which, of course, is why documentation is a Good Thing.)

xblue

hope I don't misunderstand your problem, but can't you simply use ORDER BY column_name (assuming column is a date/datetime/timestamp type field), possibly in combination with LIMIT?

Anonymouz

Originally posted by xblue
hope I don't misunderstand your problem, but can't you simply use ORDER BY column_name (assuming column is a date/datetime/timestamp type field), possibly in combination with LIMIT?

Thanks mate that really did the trick, i was probably thinking to hard..