Quick Search Form Bar

[mariano_quilmes]

Hello I was wondering if it is possible to make a form like a quick search bar without any drop down menus to search in my database in the Name, Description and Product_to_Products Extra_Fields. In product Extra Fields each item has 8 different strings in a chain, from director(ID 3) to genre (ID 8). I want to know how can I make the query to search in all these fields at once and to output like a regular oscommerce search.

 

If I Name the Imput string and compare it with a query its ok? Is there any script for search queries which I can use by modifying it?.

 

Imput Name="dataquery"

 

$cast_crew_query = "select products_id, products_extra_fields_id, products_extra_fields_value from products_to_products_extra_fields where products_to_products_extra_fields_value = '$dataquery'";

 

For example if I want to get all Megan Fox films, if I type "Megan Fox" it searches in all the IDs from all the products to match the name in for example, Product ID 2944 = Transformers 2, Extra Fields ID 4 = Shia LaBeouf, Megan Fox, Tyrese Gibson, Jon Voight so I get a possitive match and then output in a page like the advanced_search_results.php layout?

 

Here I leave a thumbnail of the database to see what I mean:

 

 

Thanks.

 

Mariano.