[Phpgroupware-cvs] property/inc/class.sogab.inc.php, 1.5

[nomail]

Update of /property/inc
Modified Files:
        Branch: 
          class.sogab.inc.php

date: 2004/10/12 13:51:41;  author: sigurdne;  state: Exp;  lines: +2 -2

Log Message:
no message
=====================================================================
Index: property/inc/class.sogab.inc.php
diff -u property/inc/class.sogab.inc.php:1.4 
property/inc/class.sogab.inc.php:1.5
--- property/inc/class.sogab.inc.php:1.4        Sat Oct  9 11:56:12 2004
+++ property/inc/class.sogab.inc.php    Tue Oct 12 13:51:41 2004
@@ -59,7 +59,7 @@
 
                        if ($order)
                        {
-                               $ordermethod = " order by $order $sort";
+                               $ordermethod = " order by 
fm_gab_location.$order $sort";
                        }
                        else
                        {
@@ -117,7 +117,7 @@
                                $on = 'AND';
                        }
 
-                       $sql = "SELECT gab_id,count(gab_id) as hits, loc" . $j 
. "_name as address, fm_gab_location.owner as owner FROM fm_gab_location 
$joinmethod $filtermethod GROUP BY gab_id,address,owner ";
+                       $sql = "SELECT gab_id,count(gab_id) as hits, loc" . $j 
. "_name as address ,fm_gab_location.location_code, fm_gab_location.owner as 
owner FROM fm_gab_location $joinmethod $filtermethod GROUP BY 
gab_id,fm_gab_location.location_code,loc" . $j . "_name,owner ";
 
                        $this->db2->query($sql,__LINE__,__FILE__);
                        $this->total_records = $this->db2->num_rows();