//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;