I have the following mysql query
SELECT Name, Summoner_Name, ROUND(SUM(timePlayed)/60) as Total_Time
FROM UserNames, games_database
WHERE (UserNames.ID = games_database.UserNames_ID AND
UserNames.ID IN ({$Member_Ids_Sql}))
GROUP BY UserNames.ID
ORDER BY Total_Time DESC;
It effectively will grab the players name, summoner names, and total play_time. It does this by using a table join. As one table Usernames, contains the users ID, Name and Summoner Name. Where as the Games_database table holds every game the player has played.
What I want to do is display the information of users that are in the UserNames table, but haven't played any games yet.
Extra Information: UserNames Database contains ID, Summoner_ID, Summoner_Name, Name
Games_database Database contains
ID, Match_ID, my_Date, timePlayed, champion, win, Summoner_ID, UserNames_ID, Game_Type
I got this working perfectly for all users with games, but when a new user enters the system, they aren't shown in this query due to no games being played.