Query Question!

[Anon]

Ok. I want to query a db in php like this:

if $m == jan01 then select Date from db (pulling all dates from 2001-01-01 through 2001-01-31)

here's the deal. i have tons of dates like jan01. (ie. dec94, feb99) How is the easiest way to do this?

Thanks a ton!
josh

[Anon]

How is your timestamp set up or your database fields. You need to be more specific in how your db schema is set up.

[chowdary]

Hi Josh,
First you need to get the month and year
$month=substr($m,0,3);

$year=substr($m,3,2);

Now use this query (For MySQL only)

$qry="SELECT * FROM $tablename WHERE LCASE(DATE_FORMAT($date_field,'%b'))='$month' AND DATE_FORMAT($date_field,'%y')='$year'";

Cheers
Ajay