Re: [Savannah-hackers-public] ORDER BY group_name first

[Sylvain Beucler]

Hi,

Sorry for the delay :)


> It is not much, but I think this might make a major
> improvement in the project search. This will
> alphabetize the group_name column (Project) so that if
> the exact search does not turn up, the user may have
> an easier time finding what they are looking for.
> In the file php/include/search/general.php line 405,
> have:
> 
> $sql .= " AND $kw_sql ORDER BY
> group_name,unix_group_name ";
> 
> instead of 
> 
> $sql .= " AND $kw_sql ORDER BY
> unix_group_name,group_name ";

Good idea! Results are indeed easier to browse for the human eye. I
applied the change.


> I am also thinking about making an exact query incase
> there is more than one result sort of like:
> 
> SELECT group_name,short_description,type FROM groups
> WHERE group_name IN('WhatYouAreLookingFor');
> 
> This way if the user really knows what they are
> looking for but does not remember the project page
> they can just get the exact result in addition to the
> similar results. My only problem is where would I put
> that query inside the code.

This query is very different from the normal query. Maybe you could
include a new function in include/search/general.php and call it from
search/index.php ?

Cheers,

-- 
Sylvain