Psycho

Frank, I concur with .josh's original post. I think you are reading something into the post that isn't there. He never stated that you can't implement AJAX without a framework. He was only stating that if you are asking for help with your AJAX implementation be prepared to be asked why you are not using a framework. Why? Because the vast majority of the people asking for help on this forum are novices. These are the people that typically get shunned in other forums because they really don't know what they are doing. These are people that may struggle with creating a simple script to query a database and generate output. AJAX is not rocket science, but it is not something the uninitiated really grasps out of the box. Trying to help someone debug issues with AJAX can be very complicated because of all the different technologies that are typically involved: PHP, MySQL, JavaScript, etc. By using a framework we don't have to read through all of their JavaScript to see if the person wrote wrote the handler correctly or not. It helps to reduce a point of failure that happens all too often. For someone that really knows what they are doing - by all means they can and should write the AJAX code to their specific needs. But, these are also the people that wouldn't need to come and post on a forum for help with it.

Steve started this thread in 2011 and it went unanswered (which I thought was surprising). Markla posted here just recently as he/she was looking for a similar solution. Steve has posted in these forums as late as a couple months ago. But, I would guess he's still not looking for a solution to this. Well, if he is, he is certainly persistent.

Yeah, I'm a terrible person that doesn't want to help people. Of course, that would be overlooking the fact that I did post a solution in this thread earlier and, of course, that would be overlooking the 9,000+ posts I have made in this forum over the years. Whereas, you were given a solution but were too lazy to implement it or try it yourself to see what it would look like.

Yeah, I noticed that. But still, this is a "help" forum, not a "do it for me" forum.

So, you have data and you have the code Barand supplied, yet you want HIM to put it together and provide a screen capture of the results? Why don't you ask him to come over and rub your feet while he's at it.

OK, using the same table structure as the original poster, this appears to work. But, not sure if it is the most efficient. SELECT * FROM (SELECT homeTeam.team_name as home_team, homeGames.all_games_id, home_goals, homeGames.date, homeGames.time FROM teams AS homeTeam LEFT JOIN all_games AS homeGames ON homeTeam.team_id = homeGames.home_team) AS home LEFT JOIN (SELECT awayTeam.team_name as away_team, awayGames.all_games_id, awayGames.away_goals FROM teams AS awayTeam LEFT JOIN all_games AS awayGames ON awayTeam.team_id = awayGames.away_team) AS away ON home.all_games_id = away.all_games_id ORDER BY home_team ASC, away_team ASC

@Barand, The poster was looking for a matrix where every team is listed down the left to represent where they are the home team, and every team is listed across the top to represent where they are the away team. Then the value of each cell is the score of that particular matchup. I don't think your solution really get that - at least not with additional work. I'm trying to solve this, but I'm sure you'll come up with something before me. I'm guessing one option is to have two subqueries. One with all teams listed joing out to the games/results tables and retireve the score for the home team in the matchups. Then do another subquery for every team to get the data where they are away. Then JOIN those two subqueries together based on game_id. At least that's my first thought.