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

[nobody]

=================== BUG #3376: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3376&group_id=509

Submitted by: powerstat               Project: phpGroupWare                 
Submitted on: Tue 04/29/2003 at 11:09
Category:  projects                   Bug Group:  None                      
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  None              
Platform Version:  None               Reproducibility:  None                

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




No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3376&group_id=509