= curdate() AND withdraw='n' and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
} else if($sub_catenum == '2') {
$sub_table = "f_recipe";
$query3 = "select anum from $sub_table where withdraw='n' and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
} else if($sub_catenum == '3') {
$sub_table = "f_grocery";
$query3 = "select anum from $sub_table where end >= curdate() AND withdraw='n' and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
} else {
if(!$c) {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '21000000' and ('21000000' + $next_range_end)) ";
} else {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
}
}
} else {
if(!$c) {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '21000000' and ('21000000' + $next_range_end)) ";
} else {
$query3 = "select anum from e_auct_master LEFT JOIN e_company USING(school_no) where valid >= curdate() AND withdrawn IS NULL and (catenum between '$catenum' and ('$catenum' + $next_range_end)) ";
}
}
$result3 = mysqli_query($query3,$connect);
$total_count = @mysqli_num_rows($result3);
if(!fmod($i,2)) {
echo("
