@Arla: You got it in one shot. Thanks. Now I'll have to do some testing to see if it is indeed any faster.
@Seif: I didn't think it would be this hard to visualize. I am reporting a table of information. In the table there is a user_id column, but I don't want the user_id of each row. I want the user name for each row.
For example, here:
http://codersblock.net/arena/ranking.php. The table "ranking" contains several rows, and a column called "user_id". I report the user name for each row by getting it from a second table. That is shown by the MySQL in my second post.
But now I need to do it where there's a user_id1 AND user_id2. Now, let's go back to my very first post.
Quote:
|
I want the username for each of these user_ids.
|
For example, here:
http://codersblock.net/arena/lobby.php. The matches table has two user_ids, and I report the user name for "each of these user_ids". This is accomplished by the MySQL from my first post, which I now want to combine into one whole query.
Read my question over again and maybe it will all fall together now. But since I've already got it working with Arla's MySQL, now I only need to optimize it if possible.