can help me to check to my search engine code,why i cant get the proper search?

weiwei

This is my search engine code, i think my code have some problem and mistake so that i cannot get the proper searching. Can anybody kelp me to correct it?

<form name="search" method="post" action="<?=$PHP_SELF?>">
Search for:
<br><input type="text" name="search">

<br><Select NAME="field">
<Option VALUE="Operation">Operation</option>
<Option VALUE="office">office</option>
<Option VALUE="comunication">comunication</option>
</select>

</form>

<?
//required file for database connection
require("config.php");
if (isset($POST['search'])) {
$search = mysql_real_escape_string($POST["search"]);
//$field=mysql_real_escape_string($_POST["field"]);
echo "<h2>Results</h2><p>";

//If they did not enter a search term we give them an error
if ($search== "") {
echo "<p>You forgot to enter a search term";
exit;
}

//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM listofitem WHERE Name LIKE '%$search%'or UPPER($field) LIKE '%$search%'");

echo "<tr><td bgcolor='#CCCCFF'>ID</th><td bgcolor='#CCCCFF'>Nama</th><td bgcolor='#CCCCFF'>Brand</td> </tr>";
//And we display the results
while($result = mysql_fetch_array( $data ))
{

echo "<tr><td><a href='InformationPage.php?id={$result['ID']}'>{$result['ID']}</a></td>
<td><a href='InformationPage.php?id={$result['Name']}'>{$result['Name']} </td>
<td>{$result['Brand']}</td>
</tr>";

}

bogu

Why do u say this?

weiwei wrote:
i think my code have some problem and mistake so that i cannot get the proper searching

what is happening, and what should happen?

weiwei

My problem here is that i realize that my search engine hv proble mwith the query part. I want to search the "Name" whether it is under the "operation","office"Or "comunication. When i click to the" operation "all the name was come out, but when i click to "office" the same output also. even for "comunication"also same. it means that the drop down box i make is not meaning there. How should i do for the query?Example?

bogu

Why did u comment this line?

//$field=mysql_real_escape_string($_POST["field"]);

BTW, when u post code on the forum, please encapsulated between php tags ([ php]...[/code]), like I did ...

anoopmail

it seems u may need something like,

SELECT * FROM listofitem WHERE Name LIKE '%$search%'or UPPER($field) LIKE '%$search%' AND <your field name>= '" . $_POST['field'] . "' "

(u can use php tags to make the code more readable 🙂)

SpinCode

Hello weiwei,
From your code, it seems that your search engine can search only single columns.
I recently found a product which will automatically generate SQL Search Statements on multiple keyword searches. It also has the ability to implement AND, OR, NOT and Phrase Searches.

http://www.addedworth.com/php/urtfer.php?t=MySearchParser

It now performs like Altavista or Google, and the filtering system is almost too good to be true.

Best of luck,
Spin