[Resolved] WHERE problem

arsenalfan14

$pl_goal_rs = $conn->Execute ( "SELECT COUNT(goal.player_id) as pl_goal, player_fname, player_lname, match_type FROM player, goal, matches WHERE goal.player_id=player.player_id AND player.player_id=" . $_GET['player_id'] . " AND matches.match_type=1 GROUP BY matches.match_type" ) or die ( $conn->ErrorMsg() );

$cl_goal_rs = $conn->Execute ( "SELECT COUNT(goal.player_id) as cl_goal, player_fname, player_lname, match_type FROM player, goal, matches WHERE goal.player_id=player.player_id AND player.player_id=" . $_GET['player_id'] . " AND matches.match_type=2 GROUP BY matches.match_type" ) or die ( $conn->ErrorMsg() );

$fac_goal_rs = $conn->Execute ( "SELECT COUNT(goal.player_id) as fac_goal, player_fname, player_lname, match_type FROM player, goal, matches WHERE goal.player_id=player.player_id AND player.player_id=" . $_GET['player_id'] . " AND matches.match_type=3 GROUP BY matches.match_type" ) or die ( $conn->ErrorMsg() );

I'm trying to get each query to return something different, based on matches.match_type.

In the HTML I have 3 different places for each, but they are all showing the same thing. The total number of goals, regardless of the match_type.

match_type is an INT.

Going to step away from the computer for like 20 minutes, this is really upsetting me. I've tried probably 50 things and none have worked!

THANKS!

YappyDog

Looks like you need to join your matches table to one of the others.

coppercoins

YappyDog is right, and it would take a peek at a DSD for your database to make full sense of it before suggesting anything. Your 'matches.match_type' needs to be connected to something else.

arsenalfan14

I have:

TABLE type_of_match

name=Premier League
match_type=1

name=FA Cup
match_type=2

name=Champions League
match_type=3

So, I have another table, where I set the match type, do I need to connect them?

matches.match_type = type_of_match.match_type AND maches.match_type=1

coppercoins

Yes, that looks correct.

arsenalfan14

Thanks mate.

Resolved.