[KW802]

OK, I'm banging my head on this one....

PHP Code:

$new_users = $DB_site->query(" 
    SELECT username, email, languageid, userid, joindate
    FROM " . TABLE_PREFIX . "user 
    WHERE '" . date('mdY', joindate) . "' = '10062004' AND 
    usergroupid IN ($ids) 
"); 


When running the above I get no hits even though I know for a fact that there are records in the user table with a join date of 10/06/2004. When I change to be not equal (!=) I get all users in the table, even those that registered on 10/06/2004!

Where'd I screw up? :ermm: