[Resolved] Producing Quad Outputs

[arsenalfan14]

By using this code, I'm getting the each row 4 times. Any ideas on why?

$arse_goal_rs = $conn->Execute ( "SELECT * FROM player, goal, matches, team WHERE goal.team_id=team.team_id AND team.team_id=1 AND goal.player_id=player.player_id AND goal.match_id=" . $_GET['match_id'] . " ORDER BY goal_time ASC" ) or die ( $conn->ErrorMsg() );

<? while ( ! $arse_goal_rs->EOF ) { ?>

<?=$arse_goal_rs->Fields("player_fname"))?>
<?=($arse_goal_rs->Fields("player_lname"))?>
<br>

<? $arse_goal_rs->MoveNext(); } ?>

If this case, there should be 1 row, but it is showing the same row 4 times.

[jubripley]

I think your problem is that you are joinging on the table matches, but you don't mention it in your WHERE clause.

You need something like
" AND matches.something_id=something_else.something_id"

[arsenalfan14]

Thanks mate.