[SOLVED] MySQL datetime, how to subtruct and show the records???

[plodos]

sql

CREATE TABLE IF NOT EXISTS `person` (
  `person_id` int(11) NOT NULL auto_increment,
  `title` varchar(20) NOT NULL,
  `fname` varchar(40) NOT NULL,
  `lname` varchar(40) NOT NULL,
  `email` varchar(128) NOT NULL,
  `date` datetime default NULL,
  PRIMARY KEY  (`person_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8  ;

 

php

$data = mysql_query("select * from person where no='1' ORDER BY lname ASC LIMIT $start,$limit"); 
             
while($info=mysql_fetch_array($data))
{
        echo title_case($info['lname'])." ".title_case($info['fname'])." <br>";
}

 

When user register the system,  information must list after 10 hours....

I will control the record, delete/update like that in 10 hour....After the 10 hours registration, information must be listed...

 

How can I do that???

[fenway]

Could you please post your solution for the benefit of others?

[plodos]

SELECT *

FROM person

WHERE no = '1'

AND date < NOW() - INTERVAL 10 HOUR

ORDER BY lname DESC

LIMIT 0 , 30

[fenway]

Apprecitaed.