[Phpgroupware-cvs] property/inc class.solocation.inc.php,1.16

[sigurdne]

Update of property/inc

Modified Files:
     Branch: MAIN
            class.solocation.inc.php lines: +2 -2

Log Message:
no message

====================================================
Index: property/inc/class.solocation.inc.php
diff -u property/inc/class.solocation.inc.php:1.15 
property/inc/class.solocation.inc.php:1.16
--- property/inc/class.solocation.inc.php:1.15  Mon May 23 09:35:13 2005
+++ property/inc/class.solocation.inc.php       Wed May 25 07:39:28 2005
@@ -1179,7 +1179,7 @@
                                'datatype' => 'D'
                        );

-                       $sql = "SELECT $table.*, $table_category.descr as 
category FROM $table $this->join $table_category on $table.category 
=$table_category.id WHERE location_code='$location_code' ORDER BY exp_date 
DESC";
+                       $sql = "SELECT $table.*, $table_category.descr as 
category FROM $table $this->left_join $table_category ON $table.category 
=$table_category.id WHERE location_code='$location_code' ORDER BY exp_date 
DESC";
                        $this->db->query($sql,__LINE__,__FILE__);

                        $j=0;