[RESOLVED] Searching between Dates

[TheFanTree]

Hello again,

I'm trying to search for users who registered between two dates.

Start Date:<input type="Text" id="betweendatea" size="10" maxlength="10">
End Date:<input type="Text" id="betweendateb" size="10" maxlength="10">

The dates are entered yyyy-mm-dd

$query = mysql_query("SELECT userid FROM test WHERE date BETWEEN '$betweendatea' AND '$betweendateb'") or die (mysql_error()); 

The dates are stored as the date type in the database in the yyyy-mm-dd format.

The problem id that even though it's not coming up with any errors it's not finding any results either.

Anyone got any ideas what I'm doing wrong?

Thanks for once again helping out a newbie in need.

[NogDog]

You may need to cast the date strings to a DATE type (or DATETIME if that is more applicable):

". . . WHERE date BETWEEN CAST('$betweendatea' AS DATE) AND CAST('$betweendateb' AS DATE)"

[TheFanTree]

Ok, Thanks

I'll give that a try this evening and see what happens.

[TheFanTree]

me again, ok I tried it. Now I get the error

Column 'date' cannot be null

Edit: Ok it's all working now. It was really obvious in the end. I forgot to add name="betweendatea" and name="betweendateb" to the input tags. It's all working now.

Thanks for you help NogDog