Author: danydb
Date: 2012-01-09 15:40:02 +0100 (Mon, 09 Jan 2012)
New Revision: 4696
Modified:
phpcompta/trunk/include/class_user.php
Log:
Filter on name or description
Modified: phpcompta/trunk/include/class_user.php
===================================================================
--- phpcompta/trunk/include/class_user.php 2012-01-09 13:49:15 UTC (rev
4695)
+++ phpcompta/trunk/include/class_user.php 2012-01-09 14:40:02 UTC (rev
4696)
@@ -971,7 +971,7 @@
else
{
$sql = "select distinct dos_id,dos_name,dos_description
from ac_dossier
- where dos_name ilike '%".sql_string($p_filter)."%' order by
dos_name";
+ where dos_name ilike '%$p_filter%' or dos_description ~*
'$p_filter' order by dos_name";
}
require_once('class_database.php');
$cn = new Database();
_______________________________________________
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
