Database

CREATE TABLE `mubadara_messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_from_name` varchar(255) DEFAULT NULL,
  `message_from_email` varchar(255) DEFAULT NULL,
  `message_subject` varchar(255) DEFAULT NULL,
  `message_body` text,
  `message_ip_address` varchar(255) DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

require 'PHPMailer/class.phpmailer.php';

$message_visitor_name = $_POST['txtName'];
$message_visitor_email = $_POST['txtEmail'];
$message_subject = $_POST['txtSubject'];
$message_body = $_POST['txtMessage'];
$message_ip_address = $_SERVER['REMOTE_ADDR'];

// save the message
$mysql_connection = mysql_connect('mysql.jassimrahma.com', 'jassimdb', 'Mujtaba2013');
mysql_select_db('jassimrahma_com', $mysql_connection);

// $mysql_connection = mysql_connect('localhost', 'root', 'xxxxxxxxxxxx');
// mysql_select_db('jassimrahma', $mysql_connection);

$mysql_command = "INSERT INTO mubadara_messages (message_from_name, message_from_email, message_subject, message_body, message_ip_address) VALUES ('$message_visitor_name', '$message_visitor_email', '$message_subject', '$message_body', '$message_ip_address')";
$mysql_result = mysql_query($mysql_command, $mysql_connection) or die(mysql_error());
// $mysql_result = mysql_query("SELECT project_name FROM projects WHERE project_id = 13");
// echo $mysql_result;
mysql_close($mysql_connection);

exit(header("Location: thankyou"));

Hi,
    I want to know if there is any way to retrieve an entire row that has a column with least creation time without using top.

Let us take a sample table named Patient
-----------------------------------------------------------
PatientId  Observation    Time                    Value
-----------------------------------------------------------
1          Temp           2014-02-19 03:55:00     35
1          Temp           2014-02-19 03:45:00     37
1          Weight         2014-02-19 03:40:00     60
 
If i am given the PatientId and Observation, I need to retrieve the the row with minimum creation time
For patient id 1 and  observation Temp this would be the row
1         Temp           2014-02-19 03:45:00     37
since it has 2014-02-19 03:45:00 as minimum creation time