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.

Igonore the first part of my problem. I'm being an idiot.

So, do you still need help with this question or did you resolve your issue?

Both now resolved. Thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.