egnjohn

Fenway, I tried to take the high road with you, I even appoligized. You don't need to keep giving me a hard time. Your right I did post php code, but I also posted mysql query code. Here is a copy/paste straight from here http://dev.mysql.com/doc/refman/5.6/en/fulltext-boolean.html This sure look pretty damn close to mine The only difference is I am assigning a php variable $results4 to the query. The $db is a global variable that is the connection to the database. So in conclusion You are correct in that there was php in my post, but there also was mysql queries in my post also. I included the php so the sql code would make sense to what I was asking. You did not need to give me a hard time at all about my post. If you believed this thread should have been in the php section you should have moved it to that section.

I figured out what was wrong i just needed to add a + to this line in front of ('{+$query}' $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE)"); Sorry for confusion, but I thought if I posted this in PHP section it would be wrong place since I needed help with a mysql select.

mysql statements: they are lines that include "sql_query("select * FROM......" iglobal $db; if($search_type=='any'){ if($criteria=='entire_bible'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('*$query*' IN BOOLEAN MODE)"); } if($criteria=='old_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('*$query*' IN BOOLEAN MODE) && testament='old'"); } if($criteria=='new_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('*$query*' IN BOOLEAN MODE) && testament='new'"); } }//if any if($search_type=='all'){ $query = ereg_replace(" ", " +", "$query"); if($criteria=='entire_bible'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE)"); } if($criteria=='old_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE) && testament='old'"); } if($criteria=='new_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE) && testament='new'"); } }//if all if($search_type=='exact'){ if($criteria=='entire_bible'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('\"{$query}\"' IN BOOLEAN MODE)"); } if($criteria=='old_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('\"{$query}\"' IN BOOLEAN MODE) && testament='old'"); } if($criteria=='new_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('\"{$query}\"' IN BOOLEAN MODE) && testament='new'"); } }//if exact if($search_type=='verse'){ $i = strrpos($query, " "); $query=substr_replace($query, ":", $i, 1); $query2 = explode(":", $query); $bookquery = $query2[0]; $chapterquery = $query2[1]; $versequery = $query2[2]; $result4 = $db->sql_query("select * FROM Bible$version WHERE book = '$bookquery' AND chapter= '$chapterquery' AND verse ='$versequery'"); }//if verse while ($row = $db->sql_fetchrow($result4)) { $testament = $row['testament']; $book = $row['book']; $chapter = $row['chapter']; $verse = $row['verse']; $scripture = $row['scripture']; echo "<b><a href=\"modules.php?name=Bible&call=chapter&viewbook=$book&viewchapter=$chapter&version=$version\">$book</a> $chapter:$verse</b>"; echo "<br>"; echo "$scripture"; echo "<hr>"; }//result 4 if(!$query){ echo "<b>You did NOT enter any keywords.</b><br>"; } if(!$scripture){ echo "<b>No results found.</b>"; }

I'm building an online Bible with a search. I do not know what I have done wrong with my coding. The search for all keywords doesnt work. I get the same results as the any keyword search. I am fairly new to coding, so it is probably a very simple fix. Please let me know what I did wrong. Below is the form and the mysql select statements. echo "<form id=\"form4\" name=\"form4\" method=\"get\" action=\"modules.php?\">"; echo "<input value=\"Bible\" name=\"name\" type=\"hidden\" />"; echo "<input value=\"search_results\" name=\"call\" type=\"hidden\" />"; echo "<input size=\"50\" name=\"query\" title=\"Search Keywords\"/>"; echo "<input value=\"$version\" type=\"hidden\" name=\"version\" />"; echo "<br />"; echo "<input value=\"entire_bible\" checked=\"checked\" type=\"radio\" name=\"criteria\" title=\"Search Entire Bible\"/>"; echo " Entire Bible"; echo " <input value=\"old_testament\" type=\"radio\" name=\"criteria\" title=\"Search Old Testament\"/>"; echo " Old Testament"; echo " <input value=\"new_testament\" type=\"radio\" name=\"criteria\" title=\"Search New Testament\"/>"; echo " New Testament"; echo "<br /><br />"; echo "<input value=\"any\" checked=\"checked\" type=\"radio\" name=\"search_type\" title=\"Match Any Word\"/>"; echo " Match Any Word"; echo " <input value=\"all\" type=\"radio\" name=\"search_type\" title=\"Match All Words\"/>"; echo " Match All Words"; echo "<br />"; echo "<input value=\"exact\" type=\"radio\" name=\"search_type\" title=\"Match Exact Phrase\"/>"; echo " Match Exact Phrase"; echo " <input value=\"verse\" type=\"radio\" name=\"search_type\" title=\"Match Book Chapter:Verse\"/>"; echo " Match Book Chapter:Verse"; echo "<br><br>"; echo "<input value=\"Submit\" type=\"submit\" />"; echo " "; echo "<input value=\"Reset\" type=\"reset\" />"; echo "</form>"; global $db; if($search_type=='any'){ if($criteria=='entire_bible'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('*$query*' IN BOOLEAN MODE)"); } if($criteria=='old_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('*$query*' IN BOOLEAN MODE) && testament='old'"); } if($criteria=='new_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('*$query*' IN BOOLEAN MODE) && testament='new'"); } }//if any if($search_type=='all'){ $query = ereg_replace(" ", " +", "$query"); if($criteria=='entire_bible'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE)"); } if($criteria=='old_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE) && testament='old'"); } if($criteria=='new_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('{$query}' IN BOOLEAN MODE) && testament='new'"); } }//if all if($search_type=='exact'){ if($criteria=='entire_bible'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('\"{$query}\"' IN BOOLEAN MODE)"); } if($criteria=='old_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('\"{$query}\"' IN BOOLEAN MODE) && testament='old'"); } if($criteria=='new_testament'){ $result4 = $db->sql_query("select * FROM Bible$version WHERE MATCH (scripture) AGAINST ('\"{$query}\"' IN BOOLEAN MODE) && testament='new'"); } }//if exact if($search_type=='verse'){ $i = strrpos($query, " "); $query=substr_replace($query, ":", $i, 1); $query2 = explode(":", $query); $bookquery = $query2[0]; $chapterquery = $query2[1]; $versequery = $query2[2]; $result4 = $db->sql_query("select * FROM Bible$version WHERE book = '$bookquery' AND chapter= '$chapterquery' AND verse ='$versequery'"); }//if verse while ($row = $db->sql_fetchrow($result4)) { $testament = $row['testament']; $book = $row['book']; $chapter = $row['chapter']; $verse = $row['verse']; $scripture = $row['scripture']; echo "<b><a href=\"modules.php?name=Bible&call=chapter&viewbook=$book&viewchapter=$chapter&version=$version\">$book</a> $chapter:$verse</b>"; echo "<br>"; echo "$scripture"; echo "<hr>"; }//result 4 if(!$query){ echo "<b>You did NOT enter any keywords.</b><br>"; } if(!$scripture){ echo "<b>No results found.</b>"; }

I considered splitting values up but that would not allow a boolean text search on keywords in the scripture field. Atleast I couldn't think of a way to use one form for both types of results.

Thank You so much, that works perfect!

I am fairly new to php, correct me if I'm wrong. This will not work on a book that has more than one word in it such as "Song of Solomon".

I am making a online Bible with search function. I was able to do the boolean search for text keywords without much trouble. Now I want a user to be able to type in an exact verse into search form and have that verse display in results. IE: User types in John 3:16 and search result displays that verse. The following works if the user types John:3:16. I cannot figure out how to do this without requiring the user to type a : after book name. if($search_type=='verse'){ $query2 = explode(":", $query); $bookquery = $query2[0]; $chapterquery = $query2[1]; $versequery = $query2[2]; $result4 = $db->sql_query("select * FROM Bible$version WHERE book = '$bookquery' AND chapter= '$chapterquery' AND verse ='$versequery'"); while ($row = $db->sql_fetchrow($result4)) { $book = $row['book']; $chapter = $row['chapter']; $verse = $row['verse']; $scripture = $row['scripture']; echo "<b><a href=\"modules.php?name=Bible&call=chapter&viewbook=$book&viewchapter=$chapter&version=$version\">$book</a> $chapter:$verse</b>"; echo "<br>"; echo "$scripture"; echo "<hr>"; } if(!$query){ echo "<b>You did NOT enter any keywords.</b><br>"; } if(!$scripture){ echo "<b>No results found.</b>"; } } } Is there a function to find first integer in the string and insert a : before it?