[21022] Improvement: fetchmode assoc 4686:4746

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)