<input type="text" name="searchstring">
when the user types in the searchstring and clicks "Submit",
pass the $searchstring variable to the query builder and build a query like this:
//split $searchstring by whitespace
$tok = strtok($_POST["searchstring"]," ");
//start of query
$temp="SELECT ..... FROM ..... WHERE ";
//look up "Honda" and "prelude" in both fields - % are wildcard chars
while($tok)
{
$temp .=
"upper(Manf) LIKE upper('%$tok%') OR upper(type) LIKE upper('%$tok%) OR";
$tok = strtok(" ");
}
//get rid of OR at end
$temp = substr_replace($temp," ",-3);
Try that...hope it helps...
