X-Cart forums

[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

[longhorn180]

Something else in 4.0.1 I'd like to do, but don't know how. When a customer searches for something, and no matches are found, it kicks them to the advanced search page, but does'nt tell them that no matches were found. I'd like to add a line to the top of the page saying:
Sorry we found no matching results. How would I go about getting this label to display when no matches are found?

[longhorn180]

Is there anyone who might be able to help me? I'm sure it's a simple fix, but I'm having a hard time figuring it out.

[snorocket]

i've had a bunch of mysql errors searching for various stuff so i think the search is a little buggy right now