Sorry, thought I did, lost my PHP I had ready to enter.
I want to have two queries:
1) To get player name, number, and player_id
2) To get the total number of apperances (using COUNT) based on how many times the player_id shows up in the db in a table.
I then want to use a loop to list like:
| FirstName LastName | Appearances
Like in a table.
Here's what I have, that doesn't work:
$arse_squad_rs= $conn->Execute ( "SELECT player.player_id, player.player_sqnumber, player.player_fname, player.player_lname, player.player_height, player.player_weight, player.team_id, team.team_id FROM player, team WHERE team.team_id=player.team_id AND player.team_id=1 AND player_active='YES' ORDER BY player_id ASC" ) or die ( $conn->ErrorMsg() );
$all_app_rs = $conn->Execute ( "SELECT COUNT(match_squad.player_id) as all_app, match_squad.player_id, player.player_id FROM player, match_squad WHERE match_squad.player_id=player.player_id AND player.player_id=player.player_id GROUP BY player.player_id ORDER BY player.player_id ASC" ) or die ( $conn->ErrorMsg() );
<?
while ( ! $arse_squad_rs->EOF ) {
$player_id = $arse_squad_rs->Fields("player_id");
$player_fname = $arse_squad_rs->Fields("player_fname");
$player_lname= $arse_squad_rs->Fields("player_lname");
?>
<tr>
<td><?=($player_fname)?> <?=($player_lname)?></td>
<td><?=number_format($all_app_rs->Fields("all_app"),0)?></td>
</tr>
<?
$arse_squad_rs->MoveNext();
}
?>
Also, having problems with an 'IF' statement. I'm not even sure you can do this, but I'd like to try.
<td align="left" bgcolor="<?
if ( $arse_squad_rs->Fields("match_sub") == 1 ) {
"#cccccc";
} else {
"#ffffcc";
}
?>
Basically match_sub is a boolean field 0 and 1. If it is 1 I want the bg for the cell to be #cccccc, if it is 0 I want it to be #ffffcc.
