0 AND `id` <> $id") or die(mysql_error()); $num = 0; while($user = mysql_fetch_array($users)) { $sites = mysql_query("SELECT * FROM `sites` WHERE `owner` = '{$user['id']}' AND `approved` = 'Y' AND `allowance` > 0") or die(mysql_error()); while($site = mysql_fetch_array($sites)) { if(($site['used'] < ($site['allowance'] / 100) * ($user['credits'] + $user['spent'])) ) { $bannercheck = mysql_num_rows(mysql_query("SELECT * FROM `banners` WHERE `site` = '{$site['id']}'")); if($bannercheck != 0) { $avsite[$num] = $site; $num++; } } } } $i = count($avsite); $k = mt_rand(0, $i - 1); if(!$avsite[0]) { $avsite[0] = mysql_fetch_array(mysql_query("SELECT * FROM `sites` WHERE `owner` = '1' AND `approved` = 'Y' AND `allowance` > 0")); $k = 0; } $banners = mysql_fetch_array(mysql_query("SELECT * FROM `banners` WHERE `site` = '{$avsite[$k]['id']}' AND `approved` = 'Y' ORDER BY RAND() LIMIT 0,1")); echo(''); mysql_query("UPDATE `accounts` SET `credits` = `credits` - 1, `used` = `used` + 1 WHERE `id` = {$avsite[$k]['owner']}"); mysql_query("UPDATE `accounts` SET `credits` = `credits` + 1 WHERE `id` = $id"); mysql_query("UPDATE `sites` SET `used` = `used` + 1 WHERE `id` = {$avsite[$k]['id']}"); ?>