Hi NG. I know this is probably very simple, but I've had no luck making it work :(
I want 1 single row out of a table, that row must be the latest by date and time. The table looks like this (example MySQL): _______________________________________________ id | type_id | date | time | title | source | --------------------------------------------------------------- 128 | 1 | 2003-01-09 | 15:00:52 | some title | blabla | 129 | 1 | 2003-01-09 | 15:02:43 | some title 2 | blabla 2 | --------------------------------------------------------------- What i need is the SQL that would give me the latest created row of these 2 (i dont mean latest as in last_id) by date and time in this case the result should be the row with id = 129 because of the time. Please help... ~ Aidal -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
