[Phpgroupware-cvs] [21022] Improvement: fetchmode assoc 4686:4746

[Sigurd Nes]

Revision: 21022
          
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=21022
Author:   sigurdne
Date:     2010-02-07 10:44:14 +0000 (Sun, 07 Feb 2010)
Log Message:
-----------
Improvement: fetchmode assoc 4686:4746

Modified Paths:
--------------
    people/sigurdne/modules/messenger/trunk/inc/class.somessenger_sql.inc.php

Modified: 
people/sigurdne/modules/messenger/trunk/inc/class.somessenger_sql.inc.php
===================================================================
--- people/sigurdne/modules/messenger/trunk/inc/class.somessenger_sql.inc.php   
2010-02-07 10:43:41 UTC (rev 21021)
+++ people/sigurdne/modules/messenger/trunk/inc/class.somessenger_sql.inc.php   
2010-02-07 10:44:14 UTC (rev 21022)
@@ -98,10 +98,10 @@
 
                function total_messages($extra_where_clause = '')
                {
-                       $this->db->query("select count(*) from 
phpgw_messenger_messages where message_owner='"
+                       $this->db->query("select count(*) as cnt from 
phpgw_messenger_messages where message_owner='"
                                . $this->owner . "' " . 
$extra_where_clause,__LINE__,__FILE__);
                        $this->db->next_record();
-                       return $this->db->f(0);
+                       return $this->db->f('cnt');
                }
 
                function delete_message($message_id)