query no longer works

[cbesh2]

I have a database that I use to track attendance for meetings. The query below used to show who did NOT show up for the meeting on a selected date. Now, after changing the "date" field to a DATE type, it no longer works (before I was using VARCHAR). I need a date type so I can subtract dates. What have I done wrong? How do I fix it? Thank you for your help in advance.

SELECT * FROM people WHERE person_id NOT IN(SELECT person_id FROM attendance WHERE date=".$_GET['date'].") ORDER BY people.lname, people.fname;

[devinemke]

the date string value must be surrounded by single quotes and the native mySQL date formatting is YYYY-MM-DD. is that what your GET var looks like?

[cbesh2]

Yes, the data in my database is in YYYY-MM-DD format. There are no single quotation marks in my database. There shouldn't be, should there?

I didn't want to complicate my post, but I'll show you my entire script:

<form>

<!-------------------------------------------->
<!-----  Create Dynamic Drop Down Menu  ------>
<!-------------------------------------------->

<?php
$query = "select * from attendance GROUP BY date"; 
$result = mysql_query($query); 
echo '<select name="date">'; 
echo '<option value="" selected>Select Date</option>'; 

/*Dynamically generate drop-down list*/ 
while ($row=mysql_fetch_array($result)) { 
$id = $row['date']; 

echo "<option value='$id'>$id</option>"; 
} 
echo '</select><p>'; 
?>

<input type=submit name=submit value="Submit">
<input type=reset name=reset value="Clear">

</form>

<!-------------------------------------------->
<!---------  Display Selected Date  ---------->
<!-------------------------------------------->

<?php
echo $date;
?>


<!-------------------------------------------->
<!---------  Display Selected Data  ---------->
<!-------------------------------------------->

<?php 
    if(!isset($_GET['date'])){ 
	    echo " ";
    } else { 
?>

 <?php
				$result= mysql_query ("
					SELECT * FROM people WHERE person_id NOT IN(SELECT person_id FROM attendance WHERE date=".$_GET['date'].") ORDER BY people.lname, people.fname;
					") or die (mysql_error());


				?>

					<table border=1>
						<tr>
							<td>
							<b>First</b>
							</td>
							<td>
							<b>Last</b>
							</td>

						</tr>

						<tr>
							<?php
								while ($row = mysql_fetch_array($result))
								{
							?>
							<td>
								<?php
									echo $row["fname"];
									echo "&nbsp;";
								?>
							</td>
							<td>
								<?php
									echo $row["lname"];
									echo "&nbsp;";
								?>
							</td>
						</tr>
						<?php
								} //end while loop
							mysql_free_result($result);
						?>

</table>

					<?php
        } //end else
	?>

[cbesh2]

The GET is taken from the dynamic pull down menu that is populated from the database. Once selected, it should list everybody who was not present at the meeting. At least, that's how it worked before I changed the type from VARCHAR to DATE.

Also, let me clarify. I am getting results but they are inaccurate. It is listing everybody in my database, not those who did not attend the meeting.