I have copied the advanced_search_results pages to create a new page called model_search. Everything works fine.

Now I have attempted to alter the SQL query to search only for an exact match on the model number. My first attempt looked something like this in the header_php.php file:

$str_2_search=$_GET['keyword'];
$where_str = " WHERE p.products_model='$str_2_search'";

and just skipping the rest of the $where_str altogether. The result was a locked MySQL. So, things are more complicated.

I don't expect anyone to spend all day working on this, but does anyone have some suggestions for building a custom SQL query. My goal here is to list all products with a certain model number. (Model numbers are not unique.)