if (!$submit) {
include('bible.inc');
}
else {
$VersesStart = explode(":", $StartVerse);
$VersesEnd = explode(":", $EndVerse);
$StartChapter = $VersesStart[0];
$StartVerse = $VersesStart[1];
$EndChapter = $VersesEnd[0];
$EndVerse = $VersesEnd[1];
$result = mysql_query ("SELECT No FROM kjvbible WHERE ( book_no = \"$book_no\" ) AND ( Chapter = \"$StartChapter\" ) AND ( Verse = \"$StartVerse\" )",$connection) or die("Error: Start Chapter and Verse not found.");;
while($myrow = mysql_fetch_array($result))
{
$StartRow = $myrow["No"];
}
$result = mysql_query ("SELECT No FROM kjvbible WHERE ( book_no = \"$book_no\" ) AND ( Chapter = \"$EndChapter\" ) AND ( Verse = \"$EndVerse\" )",$connection) or die("Error: End Chapter and Verse not found.");;
while($myrow = mysql_fetch_array($result))
{
$EndRow = $myrow["No"];
}
$PrintNum = $EndRow - $StartRow + 1;
if ($PrintNum > 50) {
echo "More than 50 verses found, printing halted at 50.";
echo "$PrintNum verse(s) found. Search Again
";
$result = mysql_query ("SELECT Book, Chapter, Verse, VerseText FROM kjvbible WHERE ( No >= \"$StartRow\" ) AND ( No <= \"$EndRow\" ) LIMIT 50",$connection);
while (list ($Book, $Chapter, $Verse, $VerseText) = mysql_fetch_row ($result)) {
echo "$Book $Chapter:$Verse $VerseText ";
}
}
else {
echo "$PrintNum verse(s) found. Search Again
";
$result = mysql_query ("SELECT Book, Chapter, Verse, VerseText FROM kjvbible WHERE ( No >= \"$StartRow\" ) AND ( No <= \"$EndRow\" ) LIMIT 50",$connection);
while (list ($Book, $Chapter, $Verse, $VerseText) = mysql_fetch_row ($result)) {
echo "$Book $Chapter:$Verse $VerseText ";
}
}
?>
include('bible.inc');
}
?>
|
include('../rightmenu.inc');
?>
include('../footer.inc');
?>