--------------------------------------------------------------- title | author | category | | -------------------------------------------------------------- xyz madman fiction adapt brainless fiction adaxx stupid fiction follow idiot journal your man acadamic --------------------------------------------------------------
<form action="search.php" method="post"> <?php $select_query= "Select distinct category from books"; $select_query_run = mysql_query($select_query); $select_query_array= mysql_fetch_array($select_query_run) ; $cat = $select_query_array['category']; echo "<select name='name'>"; while ($select_query_array= mysql_fetch_array($select_query_run) ) {// dynamic drop list echo "<option value='".htmlspecialchars($select_query_array["category"])."' >".htmlspecialchars($select_query_array["category"])."</option>"; } echo "</select>"; ?> <input type="text" name="searchvalue" size="5" id="searchfield" title="searchfield" onFocus="clearText(this)"/> <input type="submit" name="submit" value="" alt="Search" id="searchbutton" title="Search" /> </form> <?php $button = $_POST['submit']; $search = $_POST['searchvalue']; if(strlen($search)<=1) { $name = $_POST['name']; //echo $a; echo "Search term too short"; } else{ echo "You searched for $search <hr size='1'></br>"; $search_exploded = explode (" ", $search); $x = ""; $construct = ""; foreach($search_exploded as $search_each) { $x++; if($x==1) $construct .="title LIKE '%$search_each%'"; else $construct .="AND title LIKE '%$search_each%'"; } $construct ="SELECT * FROM books WHERE $construct and category = '$name'";// I tried this but not working $run = mysql_query($construct); $foundnum = mysql_num_rows($run); if ($foundnum==0) echo "Sorry, there are no matching result for $search.</br></br>1."; else { echo "$foundnum results found !<p>"; } ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)