Search query

[rakuci]

I have a option box where the user can search only on months
<?
$maand[1] = "Januari";
$maand[2] = "Februari";
$maand[3] = "Maart";
$maand[4] = "April";
$maand[5] = "Mei";
$maand[6] = "Juni";
$maand[7] = "Juli";
$maand[8] = "Augustus";
$maand[9] = "September";
$maand[10] = "Oktober";
$maand[11] = "November";
$maand[12] = "December";
?>
<select name="datum_maand" size=1>
<option selected value="">Geen voorkeur</option>
<? for ($count = 1; $count <=12; $count++) {
$selected = "";
?>
<option value="<?=$count?>" <?=$selected?>>
<?=$maand[$count]?>
</option>
<? } ?>
</select>
in my data base I have the ful date
2003-05-16
I'm curious how can I search only on 05

Thanx

[peppeto]

I don't understand the problem mate

[superwormy]

SELECT * WHERE ( date > '2003-05-00' AND date < '2003-05-32' )

[peppeto]

I think this is what you need (sorry if I'm wrong)
SELECT * FROM blah WHERE (MONTH(datum) = '" . $datum_maand . "')";

[m_tt]

I'm a little confused as well but I think he just wants to pull all dates that are in the month of 2003-05

SELECT * FROM dTable WHERE UNIX_TIMESTAMP(yourDateField) >= UNIX_TIMESTAMP('2003-05-01') AND UNIX_TIMESTAMP(yourDateField) <= UNIX_TIMESTAMP('2003-05-31')

There are many, many ways of doing this