[Phpgroupware-cvs] phpgwapi/inc class.categories.inc.php

[Dave Hall]

CVSROOT:        /cvsroot/phpgwapi
Module name:    phpgwapi
Changes by:     Dave Hall <skwashd>     06/08/29 11:15:37

Modified files:
        inc            : class.categories.inc.php 

Log message:
        another undefined variable

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/phpgwapi/inc/class.categories.inc.php?cvsroot=phpgwapi&r1=1.129&r2=1.130

Patches:
Index: class.categories.inc.php
===================================================================
RCS file: /cvsroot/phpgwapi/phpgwapi/inc/class.categories.inc.php,v
retrieving revision 1.129
retrieving revision 1.130
diff -u -b -r1.129 -r1.130
--- class.categories.inc.php    29 Aug 2006 10:53:35 -0000      1.129
+++ class.categories.inc.php    29 Aug 2006 11:15:37 -0000      1.130
@@ -7,7 +7,7 @@
        * @license http://www.gnu.org/licenses/lgpl.html GNU Lesser General 
Public License
        * @package phpgwapi
        * @subpackage utilities
-       * @version $Id: class.categories.inc.php,v 1.129 2006/08/29 10:53:35 
skwashd Exp $
+       * @version $Id: class.categories.inc.php,v 1.130 2006/08/29 11:15:37 
skwashd Exp $
        */
 
        /**
@@ -291,13 +291,13 @@
 
                        $parent_select = ' AND cat_parent=' . $parent_id;
 
+                       $querymethod = '';
                        if ($query)
                        {
                                $querymethod = " AND (cat_name LIKE '%$query%' 
OR cat_description LIKE '%$query%') ";
                        }
 
-                       $sql = "SELECT * from phpgw_categories WHERE 
(cat_appname='" . $this->app_name . "' AND" . $grant_cats . $global_cats . ")"
-                                       . $querymethod;
+                       $sql = "SELECT * FROM phpgw_categories WHERE 
(cat_appname='{$this->app_name}' AND $grant_cats $global_cats) $querymethod";
 
                        $this->db->query($sql . $parent_select . 
$ordermethod,__LINE__,__FILE__);
                        $total = $this->db->num_rows();