Logically this seems really simple. I have two tables.
One a master table (PLAYERS) of the names of all players.
The other is a table (GAMES) of the games that were actually played; this table includes stats as well as the name of the player.
How can I make a script that will tell me:
If a name is not in PLAYERS, then there is an error.
I have this to find the names of all players and their game data:
$games = "select PLAYER from GAMES order by GAME asc";
$res = mysql_query($games);
while ($t = mysql_fetch_array($res)):
How can i feed that result ( $t[PLAYER] ) through the GAMES table and get it to spit out any instances where $t[PLAYER] isn't in in the PLAYERS database?
It is causing problems with stats because when i input the data into the games table, sometimes i dont spell the player name right or sometimes i add spaces at the end of names.
Thanks!
