[DaRealShazz]

All these replies are useless (except maybe Mark's). He's asking how to write a SQL query for what he is trying to achieve. He explicitly said, "I already have the other stuff sorted out, to get the username from where it's typed in the box".

Anyway, as I understand it, you have a form that allows you to set a specific player's badge number.
I'm not sure what the table name and column names are but this should point you in the right direction.

Код:

UPDATE users SET badge='12345' WHERE user_id=42