ID: 26055 Updated by: [EMAIL PROTECTED] Reported By: kiran_jack at rediffmail dot com -Status: Open +Status: Bogus Bug Type: Strings related Operating System: apache PHP Version: 4.3.1 New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. This is not support forum. Previous Comments: ------------------------------------------------------------------------ [2003-10-31 07:51:18] kiran_jack at rediffmail dot com Description: ------------ I have a problem with a query. I'd like to make a search in a table inserting 2 or more words in the input form, using the OR. Everything works fine with 1 word but with more I obtain result only for the LAST inserted one Please reply me soon, Jack Reproduce code: --------------- <?php require 'db_connect1.php'; if ($search) // perform search only if a string was entered. { $words = explode (" ", $search); $num = COUNT ($words); WHILE ($n<$num) { $queryWhereArray = "(description like %".$words[$n]."% || keywords like %".$words[$n]."% || cost like %".$words[$n]."% )"; } $queryWhere = join(" or ",$queryWhereArray); $query = "select count(id) as k, * from search where $queryWhere group by k order by id desc"; $result = mysql_query($query); $num_rows = mysql_num_rows($result); if (!($num_rows)) { echo "Sorry - no matches were found. Please <a href=\"search1.html\">go back</a> and try some different search terms."; } else { echo "<font face=verdana,sans-serif size=-1>"; echo "Search Results:"; while ($r = mysql_fetch_array($result)) { // Begin while echo "<br>"; $id1=$r["id"]; $link1= $r["link"]; $meta= $r["description"]; $keywords1= $r["keywords"]; $figure=$r["picture"]; $price=$r["cost"]; echo "<table border=0 cellpadding=0 cellspacing=0>"; echo "<tr>"; echo "<td width=50>"; echo "$id1"; echo "</td>"; echo "<td width=500>"; echo "<a href='$link1'>"; echo "$meta"; echo "</a>"; echo "<br>"; echo "$keywords1"; echo "</td>"; echo "<td>"; echo "Rs"; echo "$price"; echo "/-"; echo "</td>"; echo "</tr>"; echo "<br>"; echo "<br>"; } // end while echo "</table>"; echo "</font>"; } } else echo "You did not enter anything to search for. Please <a href=\"search1.html\">go back</a> and enter a search word."; ?> Expected result: ---------------- i want to search the entire string ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26055&edit=1
