<div
class="post
-text" itemprop="text">
<p>I have the following mysql query</p>
<pre><
code> SELE
CT 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 DES
C;
</
code></pre>
<p>It effe
ctively 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. </p>
<p>What I want to do is display the inf
ormation of users that are in the UserNames table, but haven't played any games yet. </p>
<p>Extra Inf
ormation:
UserNames Database
contains
ID, Summoner_ID, Summoner_Name, Name</p>
<p>Games_database Database
contains</p>
<pre><
code>ID, Mat
ch_ID, my_Date, timePlayed,
champion, win, Summoner_ID, UserNames_ID, Game_Type
</
code></pre>
<p>I got this working perfe
ctly 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. </p>
</div>
4223
点击重新获取
扫码支付
余额充值