the print_r of the array is written on top. But the sql and result shows the 1st part. The result shows twice the same result:
Array
(
[0] => Array
(
[0] => Array
(
[0] => altar
[1] => RGBA(10, 0, 0, 0.2)
)
[1] => Array
(
[0] => offer
[1] => RGBA(100, 0, 0, 0.4)
)
[2] => Array
(
[0] => burn
[1] => RGBA(100, 0, 0, 0.8)
)
)
[1] => Array
(
[0] => Array
(
[0] => turn
[1] => RGBA(20, 0, 0, 0.4)
)
[1] => Array
(
[0] => unto
[1] => RGBA(100, 0, 0, 0.6)
)
)
)
<h3>1Kings 8 <img src="images/chain_small.gif" alt="linked to"> Genesis 8</h3><br>
SELECT * FROM bible WHERE (book = '11' AND chapter= '8') AND (text_data LIKE '%altar%' OR text_data LIKE '%offer%' OR text_data LIKE '%burn%') ORDER BY id ASC<br>
SELECT * FROM bible WHERE (book = '1' AND chapter= '8') AND (text_data LIKE '%altar%' OR text_data LIKE '%offer%' OR text_data LIKE '%burn%') ORDER BY id ASC<br>
CREATE TABLE IF NOT EXISTS 1kings8_and_genesis8
(1ki8_and_gen8_ID int(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,
date_time DATETIME,
postorder INT(3),
spoke INT(3),
comments varchar(1000),
joinids varchar(50),
words varchar(120),
color varchar(30)
)<br><br><br>
<h4>Altar, Offer and Burn</h4><p></p><p class="BVerse"><span class="snavlink"><a href="http://www.blueletterbible.org/Bible.cfm?b=1ki&c=8&t=KJV" target="_blank">1Kings 8</a></span> - <span class="snavlink" style="font-size: 14px; font-weight: bold;"><a href="http://www.blueletterbible.org/assets/flash/mp3bibleplayer.cfm?b=11&c=8&t=KJV" target="_blank">Listen</a></span><br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">22</span> And Solomon stood before the <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> of the LORD in the presence of all the congregation of Israel, and spread forth his hands toward heaven:<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">31</span> If any man trespass against his neighbor, and an oath be laid upon him to cause him to swear, and the oath come before thine <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> in this house:<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">54</span> And it was so, that when Solomon had made an end of praying all this prayer and supplication unto the LORD, he arose from before the <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> of the LORD, from kneeling on his knees with his hands spread up to heaven.<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">62</span> And the king, and all Israel with him, <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed sacrifice before the LORD.<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">63</span> And Solomon <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed a sacrifice of peace <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, which he <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed unto the LORD, two and twenty thousand oxen, and an hundred and twenty thousand sheep. So the king and all the children of Israel dedicated the house of the LORD.<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">64</span> The same day did the king hallow the middle of the court that was before the house of the LORD: for there he <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.8); ">burn</span>t <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and meat <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and the fat of the peace <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings: because the brazen <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> that was before the LORD was too little to receive the <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.8); ">burn</span>t <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and meat <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and the fat of the peace <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings.<br>
<br><br><br><span style="font-size: 14px; font-weight: bold;"><a href="http://www.blueletterbible.org/Bible.cfm?b=gen&c=8&t=KJV" target="_blank">Genesis 8</a></span> - <span style="font-size: 14px; font-weight: bold;"><a href="http://www.blueletterbible.org/assets/flash/mp3bibleplayer.cfm?b=1&c=8&t=KJV" target="_blank">Listen</a></span><br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">20</span> And Noah builded an <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> unto the LORD; and took of every clean beast, and of every clean fowl, and <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.8); ">burn</span>t <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings on the <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span>.<br>
</p><br><br><br><h4>Altar, Offer and Burn</h4><p></p><p class="BVerse"><span class="snavlink"><a href="http://www.blueletterbible.org/Bible.cfm?b=1ki&c=8&t=KJV" target="_blank">1Kings 8</a></span> - <span class="snavlink" style="font-size: 14px; font-weight: bold;"><a href="http://www.blueletterbible.org/assets/flash/mp3bibleplayer.cfm?b=11&c=8&t=KJV" target="_blank">Listen</a></span><br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">22</span> And Solomon stood before the <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> of the LORD in the presence of all the congregation of Israel, and spread forth his hands toward heaven:<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">31</span> If any man trespass against his neighbor, and an oath be laid upon him to cause him to swear, and the oath come before thine <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> in this house:<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">54</span> And it was so, that when Solomon had made an end of praying all this prayer and supplication unto the LORD, he arose from before the <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> of the LORD, from kneeling on his knees with his hands spread up to heaven.<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">62</span> And the king, and all Israel with him, <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed sacrifice before the LORD.<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">63</span> And Solomon <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed a sacrifice of peace <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, which he <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed unto the LORD, two and twenty thousand oxen, and an hundred and twenty thousand sheep. So the king and all the children of Israel dedicated the house of the LORD.<br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">64</span> The same day did the king hallow the middle of the court that was before the house of the LORD: for there he <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.8); ">burn</span>t <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and meat <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and the fat of the peace <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings: because the brazen <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> that was before the LORD was too little to receive the <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.8); ">burn</span>t <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and meat <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings, and the fat of the peace <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings.<br>
<br><br><br><span style="font-size: 14px; font-weight: bold;"><a href="http://www.blueletterbible.org/Bible.cfm?b=gen&c=8&t=KJV" target="_blank">Genesis 8</a></span> - <span style="font-size: 14px; font-weight: bold;"><a href="http://www.blueletterbible.org/assets/flash/mp3bibleplayer.cfm?b=1&c=8&t=KJV" target="_blank">Listen</a></span><br>
<span style="font-size: smaller; font-weight: bold; vertical-align: text-top;">20</span> And Noah builded an <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span> unto the LORD; and took of every clean beast, and of every clean fowl, and <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ed <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.8); ">burn</span>t <span class="kw" id="" style="color: RGBA(100, 0, 0, 0.4); ">offer</span>ings on the <span class="kw" id="" style="color: RGBA(10, 0, 0, 0.2); ">altar</span>.<br>
</p>
function-give.php (7.6 KB)