query problem#1

[k994519]

hi guys

I would like to do a system date compare between 2 entities on the db called start_test - end_test

Would this query work?

$query select * from table where date between 'startdate' and 'enddate'

result=($query, $link)

if result date is more than end_test give error message else go to next page......

thanks for any help given

[TheAndrew]

I dont like the between statement, i would do someting like:

$query="SELECT * FROM table WHERE date >= 'start_test' AND date <= 'end_test";

That way you shouldnt get ANYTHING thats not in your range.

Hope it helps

[LordShryku]

Both ways would work.