[Marco van Herwaarden]

Very difficult to anwer without the complete code and samples of the data, but i think the following query is the problem:

PHP Code:

            $getreport = $DB_site->query("SELECT
                blabla $thedbhome M, $thedbaway O 
                WHERE M.MatchDateTime < CURRENT_TIMESTAMP AND M.MatchReport != '' AND
                O.OpponentID = M.MatchOpponent 
                "); 


You are running this query inside a loop where you are processing all matches. In the above query you however don't select on the 'matchid' (or whatever that is called). The result is that you will get the reports of all matches, and you will be using the $reportid from the first match over and over.

PS Next time please use the [ php ] tags, makes it a lot easier to read.