Try this WHERE date_field != $date_1 OR date_field != $date_2 OR date_field != $date_3 -----Original Message----- From: Mike Baerwolf [mailto:mike@wkla.com] Sent: Friday, October 24, 2003 6:46 PM To: php-db@lists.php.net Subject: mysql field comparison to multiple variables Hello, I trying to put together a sql statement that will pull records based on a date field. I can't figure out how to compare the date field to multiple php variables. Something like this, WHERE date_field != $date_1 OR $date_2 OR $date_3 etc. etc. Thanks for the help. Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php