MYSQL: BETWEEN time Statement

[Colton.Wagner]

My problem is that the following query will return more than just the data between two times on a specific date. Here is the mysql statement I am using.

SELECT * FROM Live_Data WHERE uid='$uid' AND Post_Date='$CurrentDate' AND Post_Time BETWEEN '$StartTime' AND '$CurrentTime' ORDER BY id DESC

When it is being processed this is how the variables are filled in:

SELECT * FROM Live_Data WHERE uid='1' AND Post_Date='2013-12-05' AND Post_Time BETWEEN '14:20:00' AND '14:50:00' ORDER BY id DESC

This query will return values on occasion but will generally return nothing. Have I done something wrong in my statement above? Advanced thanks for anyone who assists me with this issue.

Thanks,

 

Colton Wagner

[mac_gyver]

what is your actual database table definition? if the date/time columns are actually character/text type and don't have leading zeros on the values, the comparisons won't work.