[Phpgroupware-tracker] [bugs #3376] Wrong database relation

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #3376] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Thu 07/15/2004 at 22:59 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
     Planned Release | None                      | 0.9.18.000







/**************************************************************************/
[bugs #3376] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=3376>
Project: phpGroupWare
Submitted by: Kai Hofmann
On: Tue 04/29/2003 at 09:09

Category:  projects
Item Group:  None
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  ceb
Status:  Open
Component Version:  None
Platform Version:  None
Reproducibility:  None
Planned Release:  0.9.18.000
Fixed Release:  


Summary:  Wrong database relation

Original Submission:  This join statement is wrong - there is no connection 
between the two tables - should be:
"phpgw_p_projects.id = join phpgw_p_hours.project_id WHERE "

                        $this->db->query("SELECT title,num,phpgw_p_projects.id 
as id FROM phpgw_p_projects $join phpgw_p_hours ON "
                                                        . 
"phpgw_p_hours.employee='" . $account_id . "' GROUP BY 
title,num,phpgw_p_projects.id",__LINE__,__FILE__);
./projects/inc/class.sostatistics.inc.php












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=3376>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/