ID: 26055
Updated by: [email][/email]
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 [url][/url] 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

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,

Reproduce code:
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

else {
echo "<font face=verdana,sans-serif size=-1>";
echo "Search Results:";
while ($r = mysql_fetch_array($result))
{ // Begin while
echo "<br>";
$link1= $r["link"];
$meta= $r["description"];
$keywords1= $r["keywords"];

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>";
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 [url][/url]