select query problem >= <= stuff

looking to retrieve data from a database with a query like this :-

$Query = "SELECT * FROM database WHERE created >= '$from' AND created <=
'$to'";

they are dates but not stored in the database as such - they are stored as
text
eg 01/08/2003

the query works fine if i just
$Query = "SELECT * FROM database WHERE created = '$from' ";
it pulls all the data with the $from variable

any ideas why it wouldnt work ?

Storing dates, numbers and such as text, varchar, or similar
string/alphanumeric datatypes, will cause MySQL to sort them by their
alphanumeric value, and not their number value.
My suggestion: Convert the dates to timestamp values, and store them as int,
double, or something of the similar.

"luna" <luna@moonbase.com> wrote in message
news:bi4nqg$6a7$1@newsg2.svr.pol.co.uk...
> looking to retrieve data from a database with a query like this :-
>
> $Query = "SELECT * FROM database WHERE created >= '$from' AND created <=
> '$to'";
>
> they are dates but not stored in the database as such - they are stored as
> text
> eg 01/08/2003
>
> the query works fine if i just
> $Query = "SELECT * FROM database WHERE created = '$from' ";
> it pulls all the data with the $from variable
>
> any ideas why it wouldnt work ?
>
>
>
>

"luna" <luna@moonbase.com> wrote in message
news:<bi4nqg$6a7$1@newsg2.svr.pol.co.uk>...
>
> looking to retrieve data from a database with a query like this :-
>
> $Query = "SELECT * FROM database WHERE created >= '$from'
> AND created <= '$to'";
>
> they are dates but not stored in the database as such - they
> are stored as text eg 01/08/2003

Unfortunately, this is not the way it works with computers.
Computers are dumb and take everything you tell them at face
value. So if something is not declared as a date, then you
shouldn't expect a computer to handle it as a date.

> the query works fine if i just
> $Query = "SELECT * FROM database WHERE created = '$from' ";
> it pulls all the data with the $from variable
>
> any ideas why it wouldnt work ?

It doesn't work because `created` is not a DATE field.

Cheers,
NC

[Nursingtschools]

burwood nursing college nursing continuing education
nursing school
accelerated nursing degree graduate nursing course
nursing career education
classesusa com legal nurse training programs take nurse classes or division 1 nursing courses
nursing colleges
nursing education issues city college of san francisco nursing
nursing programs
neonatal nursing courses nursing program college
nursing degree
nursing programs in pa nursing education classes
nurse class
nursing courses 2008 nursing certification class
practical nursing course
first nursing class international nursing courses