Earliest and latest entries

[zzz]

I haev a table keeping records. I'd like to print what was the first record entered adn was was the lates. All entries have the following format datestamp date 0000-00-00.

Should be easy but I've neevr done something like taht and haev no clue how to...

[vaaaska]

It's probably best to use two queries here...one for the first and one for the last...unless you have not very many records, but I'll assume it's grown all the time...

// select the first - returns one record
"SELECT * FROM table ORDER BY date ASC LIMIT 1"

// select the last - returns one record
"SELECT * FROM table ORDER BY date DESC LIMIT 1"

However, it is also possible that you could have two dates that are the same...so perhaps you should also store time information as well - 0000-00-00 00:00:00.

[zzz]

This is perfect. I'm not worried about dupes since my entries are months appart.