[Noalyss-commit] [noalyss] 47/65: avoid duplicate

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 4b636d74bd71587a3f027d1d46ab64cd037b926d
Author: Dany De Bontridder <address@hidden>
Date:   Sun Sep 6 06:05:19 2015 +0200

    avoid duplicate
---
 html/direct.php |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/html/direct.php b/html/direct.php
index 1c6ef20..12f0e80 100644
--- a/html/direct.php
+++ b/html/direct.php
@@ -27,7 +27,7 @@ global $g_user;
 $g_user=new User($cn);
 $g_user->Check();
 $g_user->check_dossier($_GET['gDossier']);
-$res=$cn->exec_sql("select code,description from get_profile_menu($1) where 
code ~* $2 or description ~* $3 limit 
8",array($g_user->get_profile(),$_POST['acs'],$_POST['acs']));
+$res=$cn->exec_sql("select distinct code,description from get_profile_menu($1) 
where code ~* $2 or description ~* $3 order by code limit 5  
",array($g_user->get_profile(),$_POST['acs'],$_POST['acs']));
 $nb=Database::num_row($res);
        echo "<ul>";
 for ($i = 0;$i< $nb;$i++)