Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Mysql Query? How to search between 2 dates?
I guess I got it to work with that date conversion. -
Mysql Query? How to search between 2 dates?
MySQL will only accept dates in the form of YYYY-MM-DD. If your users are entering them in a different format, in PHP you can use something like: $thedate = date ('Y-m-d', strtotime($user_entered_date)); Hey I like this idea, One question though. If the user enters 3-4-2003 when it goes to... -
Mysql Query? How to search between 2 dates?
Im using PHP to access MySql. Im new to MySQL so having some slight problems. Here is what I have to just search by the date. $query = "select * from record where ".$searchtype." like '%".$searchterm."%'"; Now I want to modify that so i can search between 2... -
Mysql Query! How to Search Between 2 dates?
Im using PHP to access MySql. Im new to MySQL so having some slight problems. Here is what I have to just search by the date. $query = "select * from record where ".$searchtype." like '%".$searchterm."%'"; Now I want to modify that so i can search between 2...- nfear24
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
