Sql help for soccer stats

3 posts by 1 authors in: Forums > CMS Builder
Last Post: August 27, 2022   (RSS)

By mbareara - August 27, 2022 - edited: August 27, 2022

Goodmorning and thank you in advance for your help

I have two tables cms_players and cms_matches

in cms_matches i have a pillbox list field ‘yellow_card’ in which i select players that receive yellow card for each match (SELECT num, CONCAT(surname," ",name) FROM `<?php echo $TABLE_PREFIX ?>players` ORDER BY surname ASC) 

Now, i have a page for each player and i would "count” number of yellow cards received from this player.

Could you help me?

By mbareara - August 27, 2022

If it wasn't a multivalue field i could use this code:

<?php $matchesPlayed = mysql_count("matches", "players_matches = " . intval($playersRecord['num']) ) ;?><?php echo $matchesPlayed;?>