plodos Posted August 30, 2008 Share Posted August 30, 2008 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??? Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2008 Share Posted August 30, 2008 SELECT * from person WERE no='1' AND date > NOW() - INTERVAL 10 HOUR ORDER BY lname ASC LIMIT $start,$limit Quote Link to comment Share on other sites More sharing options...
plodos Posted August 30, 2008 Author Share Posted August 30, 2008 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2008 Share Posted August 30, 2008 Sorry, should have been "<" to show those over 10 hours old ... AND date < NOW() - INTERVAL 10 HOUR ... Quote Link to comment Share on other sites More sharing options...
plodos Posted August 30, 2008 Author Share Posted August 30, 2008 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted August 30, 2008 Share Posted August 30, 2008 Do you have a problem with reading? NOW() - INTERVAL 10 HOUR Quote Link to comment Share on other sites More sharing options...
plodos Posted August 30, 2008 Author Share Posted August 30, 2008 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:) Quote Link to comment Share on other sites More sharing options...
keeB Posted September 3, 2008 Share Posted September 3, 2008 Do you have a problem with reading? NOW() - INTERVAL 10 HOUR Wait, what? Quote Link to comment Share on other sites More sharing options...
Barand Posted September 4, 2008 Share Posted September 4, 2008 For what are we waiting? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.