To select the banner my query is simple:
Code: Select all
SELECT * FROM `banners` ORDER BY RAND() LIMIT 1Code: Select all
SELECT * FROM `banners` WHERE `user_id` IN(SELECT `id` FROM `users` WHERE `allow_banners` = 1) ORDER BY RAND() LIMIT 1Moderator: General Moderators
Code: Select all
SELECT * FROM `banners` ORDER BY RAND() LIMIT 1Code: Select all
SELECT * FROM `banners` WHERE `user_id` IN(SELECT `id` FROM `users` WHERE `allow_banners` = 1) ORDER BY RAND() LIMIT 1Code: Select all
SELECT a.* FROM banners a, users b
WHERE a.user_id = b.id
AND b.allow_banners = 1
ORDER BY RAND() LIMIT 1
Code: Select all
SELECT a.* FROM banners a JOIN users b ON ( a.user_id = b.id)
WHERE b.allow_banners = 1
ORDER BY RAND() LIMIT 1