[Resolved] Get the latest date

[miles_rich]

Ok i have writtena query to geta deadline date and a deadline time, but i need to get the last deadlien date and time see example

Deadline 1:
Date: 2003-12-12
Time: 13:00:00

Deadline 2:
Date: 2003-12-16
Time: 13:00:00

Deadline 3:
Date: 2003-12-16
Time: 15:00:00

From this the query would need to pick up Deadline 3 as it has the latest time and date.

This is what i have so far

$query_4 = "SELECT task_deadline_date, task_deadline_time FROM tbl_pom_task WHERE job_id='1'";
				$result_4 = mysql_query($query_4) or die(error_handle("Mysql: ".mysql_error()));
				$row_4 = mysql_fetch_array($result_4);
				$task_deadline_date = $row_4[0];
				$task_deadline_time = $row_4[1];

But it just picks up all of the dates and times, i want to limit it to pick up the latest one.

[Phodetheus]

$query_4 = "SELECT task_deadline_date, task_deadline_time FROM tbl_pom_task WHERE job_id='1' ORDER BY task_deadline_date, task_deadline_time DESC LIMIT 1";  // this will select just one record ie the last
                $result_4 = mysql_query($query_4) or die(error_handle("Mysql: ".mysql_error())); 
                $row_4 = mysql_fetch_array($result_4); 
                $task_deadline_date = $row_4['task_deadline_date']; 
                $task_deadline_time = $row_4['task_deadline_time'];

Phodetheus

[miles_rich]

Thankyou, now why didnt i think of that.