Date range query not working

[maxelct]

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 looks odd to me....

 

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

[c0rnf3d]

id change the col to date

[maxelct]

thanks for that

 

I am afraid it didnt really mean a lot to me.

 

Any chance someone could expand a little bit?

 

thanks

 

E

[fenway]

Don't store dates in CHAR fields... that was it.

[maxelct]

Well yes I kind of figured that was the problem. Trouble is I have been given this database to work with.

 

What can I do to solve the problem?

[c0rnf3d]

not sure if you can just change the column type... if not, add a column for date and write some php to grab then update the date column with the date from the char column.

verify it.

delete char col.

rename date col.