search help

[itworks]

i have a site that uses 2 frames, a topFrame and a mainFrame.

in the topFrame i have a text field and a search button to perfrom a database search. when the user performs the search it calls the search.php script to process the display the results in the mainFrame.

if you use the search.php script by itself it works fine but if you use it via the search form in the topFrame you have to type the search term exactly has it is in the database.

for example to search for "how are you" you have to type either "how" or "how are you". i want it to work if you search for "how", "are" or "you" or even "h", "ar" , ETC...

why doen't it work via the search form in the topFrame?

[sbroad]

1. Post the <Form> code and the SQL statement to the message board.

2. Also try trimming your variables before you query the dbase.

3. Have you verified that when the user submits the search your query is recieving the variable correctly?

Print your $sql statement after submission and see what it reads.

4. What operating system are you using.

[itworks]

this is the form i have in the topFrame.htm page

<form action="search.php" method="post" name="search" target="mainFrame" onsubmit="search.php">
<td valign="middle"> <input type="text" name="name" value="Search" size="15"></input></td>
                  <td valign="middle"> <input type="submit" onclick="search.php" value="Search" name="Search" target="mainFrame"></input></td>

the form call the search.php script which i have attached.

please take a look and see what you think it's wrong.

thanks in advance.