X-Git-Url: http://git.ozlabs.org/?p=ccan;a=blobdiff_plain;f=web%2Fsearchengine.php;h=fdc5e9f8d0feea73958f0ea0c8732e4f89284990;hp=6117f38b864cfbc6aa2198686ded1109ff5e865c;hb=687cde2a8c561b68f17609b615eb930ea02f5aac;hpb=d2c982b37f3c4373e99e7c60c19d048de02b5919

diff --git a/web/searchengine.php b/web/searchengine.php
index 6117f38b..fdc5e9f8 100644
--- a/web/searchengine.php
+++ b/web/searchengine.php
@@ -4,11 +4,14 @@ function searchdb($text, $in, $db)
 	//search db 
 	$handle = sqlite3_open($db) or die("Could not open database");
 	if($in == 'module')
-		$query = "select * from search where title LIKE \"%$text%\"";
+		$query = "select * from search where title LIKE \"$text\" order by module,
+						author";
 	else if($in == 'author')
-		$query = "select * from search where author LIKE \"%$text%\"";
+		$query = "select * from search where author LIKE \"$text\" order by module, 
+						author";
 	else 	
-		$query = "select * from search where title LIKE \"%$text%\" or author LIKE \"%$text%\"";
+		$query = "select * from search where title LIKE \"$text\" or author LIKE \"$text\" 
+						order by module, author";
 		
 	$result = sqlite3_query($handle, $query) or die("Error in query: ".sqlite3_error($handle));
 	return $result;