7
I've got another problem...
$sql[1] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 1,45';
$sql[2] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 46,90';
$sql[3] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 91,135';
$sql[4] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 136,180';
$sql[5] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 181,225';
$sql[6] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 226,270';
$sql[7] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 271,315';
$sql[8] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 316,360';
$sql[9] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 361,405';
$sql[10] = 'SELECT `email` FROM '.$xoopsDB->prefix('users').' WHERE `level` != "0" AND `rank` != "7" AND `rank` !="13" AND `rank` !="14" LIMIT 406,450';
$email[1] = array();
$email[2] = array();
$email[3] = array();
$email[4] = array();
$email[5] = array();
$email[6] = array();
$email[7] = array();
$email[8] = array();
$email[9] = array();
$email[10] = array();
$result[1] = $xoopsDB->query($sql[1]);
$result[2] = $xoopsDB->query($sql[2]);
$result[3] = $xoopsDB->query($sql[3]);
$result[4] = $xoopsDB->query($sql[4]);
$result[5] = $xoopsDB->query($sql[5]);
$result[6] = $xoopsDB->query($sql[6]);
$result[7] = $xoopsDB->query($sql[7]);
$result[8] = $xoopsDB->query($sql[8]);
$result[9] = $xoopsDB->query($sql[9]);
$result[10] = $xoopsDB->query($sql[10]);
while ($thisemail = $xoopsDB->fetchArray($result[1])) {
$email[1][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[2])) {
$email[2][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[3])) {
$email[3][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[4])) {
$email[4][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[5])) {
$email[5][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[6])) {
$email[6][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[7])) {
$email[7][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[8])) {
$email[8][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[9])) {
$email[9][] = $thisemail['email'];
}
while ($thisemail = $xoopsDB->fetchArray($result[10])) {
$email[10][] = $thisemail['email'];
}
list($emails[1]) = $email[1];
list($emails[2]) = $email[2];
list($emails[3]) = $email[3];
list($emails[4]) = $email[4];
list($emails[5]) = $email[5];
list($emails[6]) = $email[6];
list($emails[7]) = $email[7];
list($emails[8]) = $email[8];
list($emails[9]) = $email[9];
list($emails[10]) = $email[10];
I have 450 users I need to mail with my script, so I want to break it down. The code I pasted above does the trick, but is there a way to break it down using PHP or some other XOOPS function?
I know this isn't a forum for PHP, but I'm not sure how to use for() or while() statements in the code :/