PHP/MySQL Problem: Retrieve Data From Users Table - Code With C

This topic has 3 replies, 1 voice, and was last updated 8 years, 2 months ago by SapnaVishwas.

PHP/MySQL Problem: Retrieve data from users table

WinMan Member October 12, 2016 at 2:32 pm

I’m developing a browser based MMORG and I’m stuck at a point… I retrieve data from users table, and some of the data are ID’s of other users (for example testaments… user 1 set 2 as testament). Is there any way to retrieve the username of user 2 without any other query?

#10651
ShikhaTan Member October 12, 2016 at 2:32 pm
Perhaps its an idea to post the query you’re using. And important in this case seems to be, is the user a unique value ?

Also, Im not fully sure I understand your problem but I think you’re getting more back then you’d like ?
```
SELECT username FROM Users WHERE User=2
```
Maybe the above statement would work ? It only returns the username of user2 in the table Users.
#10652

Adan Member October 12, 2016 at 2:33 pm

SELECT a.*, b.username AS testamentUser FROM users AS a LEFT JOIN users AS b ON a.testament=b.id WHERE a.id=1

#10653

SapnaVishwas Member October 12, 2016 at 2:33 pm
why would you do a join on the same table i’m assuming the id and username are both in the same row if that is not the case your user table needs to be redesigned but you could easily get all data from the table including id and username in one query by doing
```
SELECT * FROM users WHERE ID = {ID}
```
and depending on what you using to query (please don’t say mysql_*) just fetch it as an object or assoc and you’ll have all the data in one query.
#10654

Viewing 3 reply threads

You must be logged in to reply to this topic.

English