PHP RSS PHP RSS

Mysql Date search

Reply

•
•
Join Date: Sep 2008
Posts: 138
Reputation: rajeesh_rsn is an unknown quantity at this point 
Solved Threads: 0
rajeesh_rsn rajeesh_rsn is offline Offline
Junior Poster

Mysql Date search

 
0
  #1
Mar 13th, 2009
Hi
I had a mysql data base and had a date column in it.
Date is like : date("Y-m-d"),

I need to search in the data base between two days,
select users who registered between 2009-12-13 and 2009-12-25.

Please help me
thanks in advance
Reply With Quote Quick reply to this message  
•
•
Join Date: May 2007
Posts: 5
Reputation: nkoepnick is an unknown quantity at this point 
Solved Threads: 0
nkoepnick's Avatar
nkoepnick nkoepnick is offline Offline
Newbie Poster

Re: Mysql Date search

 
0
  #2
Mar 13th, 2009
SELECT * FROM `table_name` WHERE (DateCol >= "2009-12-13") AND (DateCol <= "2009-12-25")
Knowing is half the battle.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



ajax apache api array basics beginner binary bounce broken cakephp checkbox class cms code codingproblem combobox cron curl database date display dynamic echo email error file files folder form forms function functions google href htaccess html image include insert integration interactive ip java javascript joomla js limit link login mail menu mlm mobile multiple mysql nodes oop outofmemmory paging parse paypal pdf php problem procedure query radio ram random recursion regex remote return script search server sessions smash sms soap source space sql syntax system table tutorial up-to-date update upload url validation validator variable video web webapplications websitecontactform xml youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC