[Electrifying]

Quote:

Originally Posted by Calisthenics `SELECT * FROM table_name` will fetch ANY column. Do not use this unless you want to retrieve everything for a player. There is `COUNT` aggregate function which returns a 0/1 in your case. You still execute 2 queries to check and update. All this can be done in 1 query using the keyword `IGNORE` and affected rows. Set the column for username as UNIQUE KEY and then execute your update query: pawn Код: UPDATE IGNORE table_name SET ... after executing the query, check how many rows were affected. If it is 0, this means there is a player with this name and hid the warning (for duplicate) as it was instructed to (by the keyword `IGNORE`). If the affected rows is 1, it updated the new name.

Thanks, and how do I send a message to the player warning that it did not work?