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: