Menu
Community /Pin to ProfileBookmark
@NogDogMar 05.2007 — #You don't tell us what format $FirstDate and $SecondDate are. Whatever they are, they need to end up in "yyyy-mm-dd" format. So for this example I will assume they have been set in that format (if not, see the date(), strtotime(), and mktime() functions for ways to do this):
Problem with SQL
Hello
I am using the following code:
[COLOR=”red”]$query = “SELECT * FROM tblONE WHERE ‘%”.$SecondDate.”%’> TDate > ‘%”.$FirstDate.”%’ ORDER BY TId DESC”;
To search a MySQL database. TDate is Timestamp(8). So it shows the date like this:
[COLOR=”red”]22.01.2007 >>> 20070122
[COLOR=”Red”]$FirstDate and $SecondDate are two variables that set my desired date range.
So I want to find all the record with TDate that fall between these two dates.
[B]I am getting wrong answers is some cases!
What am I doing wrong?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogMar 05.2007 — #You don't tell us what format $FirstDate and $SecondDate are. Whatever they are, they need to end up in "yyyy-mm-dd" format. So for this example I will assume they have been set in that format (if not, see the date(), strtotime(), and mktime() functions for ways to do this):[code=php]
$query = "SELECT * FROM tblONE WHERE CAST(TDate AS DATE) BETWEEN CAST('$FirstDate' AS DATE) AND CAST('$SecondDate' AS DATE) ORDER BY TId DESC";
[/code]