Date Problem

[maskme]

Hi!

I've 2 date fields say "From Date" & "To Date". I want to query the database such that the records between the entered dates (FROM DATE & TO DATE) appear. Is there anything like 'between' in query statements, if so please give me an example.

thanx
yusuf

[Anon]

Look here:

http://www.w3schools.com/sql/sql_between.asp

Hope this helps

fLIPIS

[buck2bcr]

I've used this in the past:

$query_hours = "SELECT * FROM hours WHERE badge=\"$badge\" AND day >= \"$start\" AND day <= \"$finish\" ";

Hope it helps.