1.11M Members

Dreamweaver Recordset issue

 
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.

 
0
 

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

 
0
 

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

 
0
 

Both now resolved. Thanks.

Question Answered as of 1 Year Ago by JorgeM
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article