Handling Dates in Mysql BETWEEN AND

[Colton.Wagner]

Hello,
 
I am trying to query my mysql database to return data based on a date range set.
 
here is the code that is returning an empty set.
 
The format is accepeted but will never return anything. Any help would be greatly appreciated.

SELECT * FROM (SELECT * FROM Live_Data WHERE uid='1' 'Post_Date' >= \"2013-11-21\" AND 'Post_Date' <= \"2013-11-22\" ORDER BY id DESC) tmp ORDER BY tmp.id ASC


or 



SELECT * FROM (SELECT * FROM Live_Data WHERE uid='$uid' 'Post_Date' BETWEEN '2013-11-21' AND '2013-11-22' ORDER BY id DESC) tmp ORDER BY tmp.id ASC

[jazzman1]

Use mysql_error() or other mysql* error functions you should get a syntax error.

[ranienter]

Try this:

 

SELECT * FROM 

(

SELECT * FROM Live_Data 

WHERE uid='$uid'

AND 'Post_Date' > '2013-11-21' 

AND 'Post_Date' <'2013-11-22' 

ORDER BY id DESC

) tmp

 

ORDER BY tmp.id ASC

 

 

I encourage you not to use BETWEEN.

[Barand]

I encourage you not to use BETWEEN.

 

 

Please explain why.