Home and Away match Table structure.

I am having the same structure but my question is that when I tryin to keep score of the home and away match ...then there is a problem since the I'd of the row is same for home and away team. ..

Why is that a problem? The ID is the ID of the game. To find all games for a team, check for rows where the team is either the home team or the away team.

How do I score the home match ...and then the away match ? Both of them have the same ID ..so how do I differentiate the home match frm the away ??

I still don't get it. If you have a Match, with a HomeTeam, an AwayTeam and two goal-columns, then you'd score a few points to the winner and a no points to the loser, or score some for both teams if it's a draw. Since the home-game and the away-game is the same game, it wouldn't make sense to separate them into two games. But I agree more and more with @Blackhawk-17 - post your DDL for the table(s) and post how you have tried to solve the problem so far.

In one match, you have a HomeTeamID and an AwayTeamID. If you examine MatchID=x, and wants to know the score from the match where the HomeTeam was the AwayTeam and vice versa, you'd do (something along the line):

SELECT m2.* FROM Matches m
INNER JOIN Matches m2
ON m.HomeTeamID = m2.AwayTeamID
AND m.AwayTeamID = m2.HomeTeamID
AND m.MatchID=x