King James Bible
King James Version (KJV)

' /> " /> " />

- if ($orderby == 'r') {$orderby = "order by `kjvnobrackets`.`id`"; ?> Sort By Relevance
} else { ?> Sort By Book Order } // end of else ?>
/*$query= "select book,chapter,startverse,endchapter,endverse, `kjv`.`id`, vtext from topicsnew
LEFT JOIN `kjv` ON topicsnew.book = `kjv`.`bname` and topicsnew.chapter = `kjv`.`cnum` and topicsnew.startverse = `kjv`.`vnum` where topicid = '".$topicid."' $orderby limit 100";
*/
$query= "select book,chapter,startverse,endchapter,endverse, `kjvnobrackets`.`id`, `vtext` from topicsnew
LEFT JOIN `kjvnobrackets` ON topicsnew.book = `kjvnobrackets`.`bname` and topicsnew.chapter = `kjvnobrackets`.`cnum` and topicsnew.startverse = `kjvnobrackets`.`vnum` where topicid = '".$topicid."' $orderby limit 100";
$query_resultsa=mysqli_query($dbb,$query);
if(mysqli_num_rows($query_resultsa) >0 ){
while($row=mysqli_fetch_assoc($query_resultsa)){
$urlbook =str_replace(' ', '-',$row['book']);
if (!empty($row['vtext'])) {
//only show content if vtext is there, because the table 'topics' has some bad verse refs that don't exist, like Psalms 127:8, Psalms 127:17, etc.
echo "";
if (!empty($row['endverse']))
{
//search [ and replace , and ] and to make to italics (easier to read and that's the intent of [] anyway
$vtext = $row['vtext'];
//$vtext = str_replace("[","",$vtext);
//$vtext = str_replace("]","",$vtext);
// I want to replace the [ ] with italics, but this screws it up when in itemprop format
echo "";
echo $row['book']." ".$row['chapter'].":".$row['startverse'];
//if end chapter is different, then show text differently
if ($row['chapter'] == $row['endchapter'])
{echo "-".$row['endverse'];}
else
{echo " - ".$row['endchapter'].":".$row['endverse'];}
echo "";
echo " - ".$vtext."";
echo " ";
echo "(Read More...)";
echo "";
echo "
";
}
else
{
echo "";
echo $row['book']." ".$row['chapter'].":".$row['startverse'];
echo "";
echo " - ".$row['vtext']."";
echo "
";
}
echo "";
}
}
}
echo "
Topics and verses are auto-generated from user searches. If a verse or topic does not belong, please contact us. Some scripture references/categories courtesy of Open Bible .info under CC BY 3.0
"; ?>";
$words = $keyword;
$filters = "";
$words = explode(" ",$keyword);
for($i=0;$words[$i] != "";$i++)
{
$length = strlen($words[$i]);
//echo $length;
if($length <= 3) continue;
//echo "WORD: '".$words[$i]."' - end of word
";
//WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'
$filters .= "term REGEXP '[[:<:]]".$words[$i]."[[:>:]]'";
//$filters .= "term like '%".$words[$i]."%'";
if($words[$i+1] != "")
$filters .= " OR ";
else
break;
}
$query="SELECT * FROM `dictionary` WHERE ".$filters;
$resultb = mysqli_query($dbb,$query);
$match_resultsb=mysqli_num_rows($resultb);
//echo $match_resultsb;
//echo $query;
if($match_resultsb > 0)
{echo "Related Bible Dictionary Terms:
";
while($relatedterms = mysqli_fetch_array($resultb))
//for ($i = 0; $i < $match_results && $i < 20; $i++) // sets max results
{
$trent = $relatedterms["term"];
$trent = preg_replace('/\s+/', '-', $relatedterms);
echo "",($relatedterms ['term'] ), " ";
}
echo "
";
// end of related matches
}
?>
Search the King James Version (KJV) for more references about Math...