469,625 Members | 1,078 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

where.. between

hai..

i'm doing a program about searching. but, i have some probem when using 'between'. this is my program:

SELECT eID, REPLACE(eTitle, '''', '''')as eTitle, REPLACE(eDescription, '''', '''')as eDescription, eSystemID, eDateStart, eDateEnd, eDurationSet, eDateCreated, eAuthorID, eTemplate, eStatus FROM vm_examdb.vm_examset WHERE eStatus = 'Approved' BETWEEN DATE_FORMAT(eDateStart, '%Y-%m-%d') <= '2006-06-21' AND DATE_FORMAT(eDateEnd, '%Y-%m-%d') >= '2006-06-21' OR DATE_FORMAT(eDateStart, '%Y-%m-%d') = '0000-00-00' ORDER BY eID ASC

the problem is, the system does not sort the eStatus = 'Approved'.
can anyone help me
Jun 21 '06 #1
1 3613
hy sakurasyi

try to change data format dd-mm-yyy, or check format columns in the table. Evrithing in write correct

bye
Jul 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Rachel Weeden | last post: by
17 posts views Thread by Jonas Rundberg | last post: by
1 post views Thread by mychevworld | last post: by
8 posts views Thread by Mike Charney | last post: by
23 posts views Thread by gord | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.