[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???

[Barand]

SELECT * from person

WERE no='1'

AND date > NOW() - INTERVAL 10 HOUR

ORDER BY lname ASC LIMIT $start,$limit

[plodos]

thanks for urgent reply but i didnt compile these codes

SELECT * from person
WHERE no='1'
AND date > NOW() - 10
ORDER BY lname DESC

 

SELECT * from person
WHERE no='1'
AND date > NOW() - 10:00:00
ORDER BY lname DESC 

 

SELECT * from person
WHERE no='1'
AND date > NOW() - 2008-08-24 10:00:00
ORDER BY lname DESC 

 

SELECT * from person
WHERE no='1'
AND date > NOW() - 0000-00-00 10:00:00
ORDER BY lname DESC 

[Barand]

Sorry, should have been "<" to show those over 10 hours old

 

... AND date < NOW() - INTERVAL 10 HOUR ...

[plodos]

thanks for urgent reply, what must I write for subtruct, I didnt find the correct format...

NOW( ) -2008 -30 -0810 :00 :00

NOW( ) -10

NOW( ) -0000 -00 -0010 :00 :00

NOW( ) -10 :00 :00

 

SELECT *
FROM person
WHERE no = '1'
AND date < NOW( ) -2008 -30 -0810 :00 :00
ORDER BY lname DESC
LIMIT 0 , 30

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10:00:00
ORDER BY lname DESC
LIMIT 0, 30' at line 3 

 

 SELECT *
FROM person
WHERE no = '1'
AND date < NOW( ) -0000 -00 -0010 :00 :00
ORDER BY lname DESC
LIMIT 0 , 30

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10:00:00
ORDER BY lname DESC
LIMIT 0, 30' at line 3 

 

 SELECT *
FROM person
WHERE no = '1'
AND date < NOW( ) -10 :00 :00
ORDER BY lname DESC
LIMIT 0 , 30

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':00:00
ORDER BY lname DESC
LIMIT 0, 30' at line 3 

[Barand]

Do you have a problem with reading?

 

 

NOW() - INTERVAL 10 HOUR

[plodos]

It is working now

 

SELECT *

FROM person

WHERE no = '1'

AND date < NOW() - INTERVAL 10 HOUR

ORDER BY lname DESC

LIMIT 0 , 30

 

 

thats true, thnx:)

[keeB]

Do you have a problem with reading?

 

 

NOW() - INTERVAL 10 HOUR

 

Wait, what?

[Barand]

For what are we waiting?