4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Comparing Date Unix time in Mysql with Nowdate -1
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
neochandra
Junior WebHelper
Junior WebHelper


Joined: 09 Apr 2007
Posts: 1
Location: Indonesia

PostPosted: Mon Apr 09, 2007 5:10 am (10 years, 6 months ago) Reply with QuoteBack to Top

My data looks like rows below:

ID | Name | Email | phone | Outlet | Remarks | Date_reg

records data is :

1 | chandra | chandra@yahoo.com | 041182083812 | 8 | 8 | 1176086033
2 | neng | neng@yahoo.com |84234823 | 0 | 0 | 1175999633

What i want to do is to SELECT rows which Date_reg = Nowdate - 1; (last date registered)

please help me to resolve my problem.

________________________________
Regards,

Harry
OfflineView User's ProfileFind all posts by neochandraSend Personal MessageYahoo Messenger
satishbhawra37
Junior WebHelper
Junior WebHelper


Joined: 25 Sep 2009
Posts: 2

PostPosted: Fri Sep 25, 2009 6:07 pm (8 years ago) Reply with QuoteBack to Top

What i want to do is to SELECT rows which Date_reg = Nowdate - 1; (last date registered)

________________________________
Best hosting | website information
OfflineView User's ProfileFind all posts by satishbhawra37Send Personal MessageVisit Poster's Website
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.066228 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme