// start of showing other translations
// 1611kjv version
$result = mysqli_query($dbb,"SELECT vtext
FROM kjv
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result) > 0)
{ //GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo "- King James Version
";
}
// asv version
$result = mysqli_query($dbb,"SELECT vtext FROM `newamericanstandard`
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error()); //GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- New American Standard Version (1995)
';
}
// asv version
$result = mysqli_query($dbb,"SELECT vtext FROM asvbible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- American Standard Version (1901)
';
}
// basicenglishbible
$result = mysqli_query($dbb,"SELECT vtext FROM basicenglishbible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Basic English Bible
';
}
//Darby Bible
$result = mysqli_query($dbb,"SELECT vtext FROM darbybible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext']. " ";
echo '- Darby Bible
';
}
/*
// - Trent, I removed douay-rheims bible on 5-22-2013, because it doesn't match the KJV text, seems to start getting off track Psalms 11:1 onward. Would take significant effort to match it up.
// douayrheimsbible
$result = mysqli_query($dbb,"SELECT vtext FROM douayrheimsbible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Douay Rheims Bible
';
}
*/
// websterbible
$result = mysqli_query($dbb,"SELECT vtext FROM websterbible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Webster\'s Bible
';
}
// weymouthbiblent
$result = mysqli_query($dbb,"SELECT vtext FROM weymouthbiblent
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Weymouth Bible
';
}
// worldenglishbible
$result = mysqli_query($dbb,"SELECT vtext FROM worldenglishbible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- World English Bible
';
}
// wycliffebiblent
$result = mysqli_query($dbb,"SELECT vtext FROM wycliffebiblent
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Wycliffe Bible
';
}
// youngliteralbible
$result = mysqli_query($dbb,"SELECT vtext FROM youngliteralbible
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Youngs Literal Bible
';
}
// jewishpsbibleot
$result = mysqli_query($dbb,"SELECT vtext FROM jewishpsbibleot
WHERE `bnum` = '".$bnum."'
AND `cnum` = '".$chapter."'
AND `vnum` = '".$verse."'
LIMIT 1;"
) or die(mysqli_error());
//GPH FT changes
if(mysqli_num_rows($result)>0)
{
//GPH FT - we remove while loop bcz here we need only one row
$row = mysqli_fetch_assoc( $result );
echo $row['vtext'] . " ";
echo '- Jewish Publication Society Bible
// start of showing other translations // 1611kjv version $result = mysqli_query($dbb,"SELECT vtext FROM kjv WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result) > 0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo "- King James Version
"; } // asv version $result = mysqli_query($dbb,"SELECT vtext FROM `newamericanstandard` WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- New American Standard Version (1995)
'; } // asv version $result = mysqli_query($dbb,"SELECT vtext FROM asvbible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- American Standard Version (1901)
'; } // basicenglishbible $result = mysqli_query($dbb,"SELECT vtext FROM basicenglishbible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Basic English Bible
'; } //Darby Bible $result = mysqli_query($dbb,"SELECT vtext FROM darbybible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext']. "
"; echo '- Darby Bible
'; } /* // - Trent, I removed douay-rheims bible on 5-22-2013, because it doesn't match the KJV text, seems to start getting off track Psalms 11:1 onward. Would take significant effort to match it up. // douayrheimsbible $result = mysqli_query($dbb,"SELECT vtext FROM douayrheimsbible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Douay Rheims Bible
'; } */ // websterbible $result = mysqli_query($dbb,"SELECT vtext FROM websterbible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Webster\'s Bible
'; } // weymouthbiblent $result = mysqli_query($dbb,"SELECT vtext FROM weymouthbiblent WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Weymouth Bible
'; } // worldenglishbible $result = mysqli_query($dbb,"SELECT vtext FROM worldenglishbible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- World English Bible
'; } // wycliffebiblent $result = mysqli_query($dbb,"SELECT vtext FROM wycliffebiblent WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Wycliffe Bible
'; } // youngliteralbible $result = mysqli_query($dbb,"SELECT vtext FROM youngliteralbible WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Youngs Literal Bible
'; } // jewishpsbibleot $result = mysqli_query($dbb,"SELECT vtext FROM jewishpsbibleot WHERE `bnum` = '".$bnum."' AND `cnum` = '".$chapter."' AND `vnum` = '".$verse."' LIMIT 1;" ) or die(mysqli_error()); //GPH FT changes if(mysqli_num_rows($result)>0) { //GPH FT - we remove while loop bcz here we need only one row $row = mysqli_fetch_assoc( $result ); echo $row['vtext'] . "
"; echo '- Jewish Publication Society Bible
'; } ?>