Bingo
$sqls = Array();
$sql13 ="";
$sql13part = "SELECT * FROM ".$dbTable3." WHERE ";
$sql13parta = "(book = ".$b1." AND chapter = ".$c1.") AND (";
$sql13partb = "(book = ".$b2." AND chapter = ".$c2.") AND (";
for($j=0; $j<count($joinidsArr); $j++){
for($k=0; $k<count($joinidsArr[$j]); $k++){
$sql13 .= "text_data LIKE '%".$words12[$joinidsArr[$j][$k]-1]."%' ";
if($k<count($joinidsArr[$j])-1){
$sql13 .= "OR ";
}
}
$sql13 .= ") ORDER by ID ASC";
$sql13a = $sql13part.$sql13parta.$sql13;
$sql13b = $sql13part.$sql13partb.$sql13;
array_push($sqls, Array($sql13a, $sql13b));
$sql13 ="";
}
echo "<br /><br /><br />\n";
print_r($sqls);
output:
Array
(
[0] => Array
(
[0] => SELECT * FROM bible WHERE (book = 11 AND chapter = 8) AND (text_data LIKE '%altar%' OR text_data LIKE '%offer%' ) ORDER by ID ASC
[1] => SELECT * FROM bible WHERE (book = 1 AND chapter = 8) AND (text_data LIKE '%altar%' OR text_data LIKE '%offer%' ) ORDER by ID ASC
)
[1] => Array
(
[0] => SELECT * FROM bible WHERE (book = 11 AND chapter = 8) AND (text_data LIKE '%turn%' OR text_data LIKE '%unto%' ) ORDER by ID ASC
[1] => SELECT * FROM bible WHERE (book = 1 AND chapter = 8) AND (text_data LIKE '%turn%' OR text_data LIKE '%unto%' ) ORDER by ID ASC
)
)