0

Hi all,

I'm trying to use recordset to create the following query:

$query_GetCurMonthPlayerGoals = "SELECT PlayerName, Goals FROM ( 
    SELECT PlayerID, COUNT(*) AS Goals 
    FROM Master 
    WHERE TeamID=$row_GetTeamDetails['TeamID'] 
    AND 
    MONTH(GoalDate)=MONTH(CURDATE()) 
    GROUP BY PlayerID 
    ORDER BY Goals DESC 
    ) T 
    INNER JOIN Master_Players 
    ON T.PlayerID=Master_Players.PlayerNameCode";

The problem I am having is that instead of;

$row_GetCurMonthPlayerGoals['PlayerName']
$row_GetCurMonthPlayerGoals['Goals']

I am getting;

$row_GetCurMonthPlayerGoals['PlayerID']
$row_GetCurMonthPlayerGoals['Goals']

How do I solve this?

The other thing I am wondering about is this line;

WHERE TeamID=$row_GetTeamDetails['TeamID']

where I am wondering if this is the correct way to insert this PHP variable into the MySQL query?

Thanks in advance for any help offered.

2
Contributors
3
Replies
6
Views
4 Years
Discussion Span
Last Post by Tinnin
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.