[longhorn180]

I installed 4.0(upgraded to 4.0.1) and have customized the search features on the customer's advanced search page somewhat. Instead of searching by short description and full descrition, i changed them to author and isbn and edited the search.php to reflect the changes. This works fine with 1 exception, if a customer wants to search by author they have to enter the name the way it is input into the database(last name, first name) or enter just the last name only. I would like them to be able to enter the author's first then last name, ex: Stephen King, and have the results displayed as well. I'm unsure of the correct way to do this and any help would be greatly appreciated. I believe this is the code I need to edit.

# Search for substring in some fields...
		
		if (!empty($data["by_title"]))
			$condition[] = "$sql_tbl[products].product LIKE '%".$data["substring"]."%'";
		
	 	if (!empty($data["by_Author"]))
		 	$condition[] = "$sql_tbl[products].Author LIKE '%".$data["substring"]."%'";

	 	if (!empty($data["by_isbn"]))
			$condition[] = "$sql_tbl[products].isbn LIKE '%".$data["substring"]."%'";

Version 4.0.1