using forms present info from db

[chill84]

i need a little help. i have a form written and it is in a drop down format. i want the user to be able to select a date from the list and then have the data from that month displayed. i was thinking of accomplishing this by

$result = @('SELECT * FROM alumni_meeting WHERE Date = $_POST['D1'];');
if (!$result) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}

this does not work how can i put the selected date in that spot where "$_POST['D1'];" is.

[devinemke]

is the dropdown simply a list of months? if so:

$result = @mysql_query("SELECT * FROM alumni_meeting WHERE MONTH(Date) = '" . $_POST['D1'] . "'");
if (!$result) {exit(mysql_error());}

be advised that this will pull all records from the selected month regardless of year.