date range query not working

[maxelcat]

Hi

I have a database that stores dates as yyyy-mm-dd and I need to query it using yyyy
I noticed that the field where this date is stored is of type char(10) - which I know is wrong, but that's what I have been given to work with...

The uers puts in $dateInput and I added 01.01 and 12.31 to the yyyy like this:

$lowDate = $dateInput.'-01-01';
$highDate = $dateInput.'-12-31';

and so get this query:

.... WHERE table.field BETWEEN 2000-01-01 AND 2000-12-13

if ($result) shows ture but the query provides no returns which I know it should because i have looked at the data.

Could anybody please help me. Is it something to do with the field type or am I doing something wrong with the query?

thanks

E

[NogDog]

The dates are strings in your SQL, so they need to be quoted. Otherwise you are giving it an arithmetic expression: 2008 minus 01 minus 01, which would mean you are essentially doing the same as:

. . . WHERE table.field BETWEEN 2006 AND 1975

[maxelcat]

thanks - did that and appears to work fine!