last registered player mysql
#1

nvm thx
Reply
#2

Well if you use IDs, you can do something like:

Код:
SELECT `Username` FROM `player_table` ORDER BY `ID` DESC LIMIT 1
There's really no need to get all of his data. You just want the username(I guess).
Reply
#3

did not work and I don't use ids
Reply
#4

Wait, what? What is your primary key in table? Name? Please attach screenshot of table structure (I hope you use phpmyadmin or some manager like mysql workbench)
Reply
#5

Quote:
Originally Posted by gtakillerIV
Посмотреть сообщение
Well if you use IDs, you can do something like:

Код:
SELECT `Username` FROM `player_table` ORDER BY `ID` DESC LIMIT 1
There's really no need to get all of his data. You just want the username(I guess).
Hi,

I don't know how to solve COL's problem but, I want to know how can you extract and use the first username after you selected it.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)