[CyberRanger]

Originally Posted by hugojr

here is the error I am getting

Invalid SQL: 
		SELECT username, userid, birthday
		FROM ?.?user
		WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
		AND usergroupid IN (0, 6, 7, 2, 5)
		
	
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?.?user
		WHERE (birthday LIKE '10-30-%' OR birthday LIKE '10-31-%')
		AND use' at line 2

mysql error number: 1064

what does this mean?

Can you post what you have in includes/functions_databuild.php from line 840 to 846? It should look like this (assuming you've replaced " . TABLE_PREFIX . " with "."

PHP Code:

    $bdays = $DB_site->query("
        SELECT username, userid, birthday
        FROM "."user
        WHERE (birthday LIKE '$todayneggmt-%' OR birthday LIKE '$todayposgmt-%')
        AND usergroupid IN ($usergroupids)
        $activitycut
    "); 


What do you have there?