Mysql/PHP query problem with datetime field.
 

I am trying to use a SELECT query to retrieve the earliest and the latest date/ time entries from my table. The field is a datetime (YYYY-MM-DD HH-MM-SS). I cannot find anything related to querying datetime in the MySQL manual.

What is the proper way to approach this?:confused:

When I do a $firstdate = mysql_query("SELECT MIN(datestamp) from seminar")
and then echo $firstdate I get the following
Resource id #5

Well actually when you use mysql_query you do not get the result stored in the $firstdate, instead you get a result set which can be used. For more information please consult PHP manual: mysql_query

As it turns out using MIN and MAX on a datetime field doesn't work the way I expected. It returns more than one record in decending order by value. I went with a mysql_fetch_array() and then set $i=mysql_num_rows($fetch) and did a mysql_data_seek($fetch, $i). Worked like a charm. Thanks anyway markus.