RootForum Community

SELECT bb1_users.userid, bb1_users.username, bb1_users.birthday, bb1_userfields.userid, bb1_userfields.field6 AS username, bb1_userfields.field7 AS birthday, bb1_userfields.userid, bb1_userfields.field11 AS username, bb1_userfields.field12 AS birthday, bb1_userfields.userid, bb1_userfields.field14 AS username, bb1_userfields.field15 AS birthday
FROM bb1_users, bb1_userfields
WHERE bb1_users.birthday LIKE '%-06-23'
AND bb1_userfields.field7 LIKE '%-06-23'
AND bb1_userfields.field12 LIKE '%-06-23'
AND bb1_userfields.field15 LIKE '%-06-23'
LIMIT 0 , 30

userid username birthday userid username birthday userid username birthday userid username birthday
1 Testuser 2008-06-23 1 Testhund 2007-06-23 1 Testhund2 2006-06-23 1 Testhund3 2005-06-23

userid username birthday
1 Testuser 2008-06-23
1 Testhund 2007-06-23
1 Testhund2 2006-06-23
1 Testhund3 2005-06-23

$result = $db->unbuffered_query("SELECT userid, username, birthday FROM bb".$n."_users WHERE birthday LIKE '%-".$currentdate."' UNION SELECT userid, field6 AS username, field21 AS birthday FROM bb".$n."_userfields WHERE field21 LIKE '%-".$currentdate."' UNION SELECT userid, field22 AS username, field23 AS birthday FROM bb".$n."_userfields WHERE field23 LIKE '%-".$currentdate."' UNION SELECT userid, field25 AS username, field26 AS birthday FROM bb".$n."_userfields WHERE field26 LIKE '%-".$currentdate."' UNION SELECT userid, field28 AS username, field29 AS birthday FROM bb".$n."_userfields WHERE field29 LIKE '%-".$currentdate."' ORDER BY username ASC");