[kirk]

Quote:

Originally Posted by xantowskii PHP код: $query="SELECT * FROM users WHERE Playername='$player_name'";  Shouldn't it be PHP код: $query="SELECT * FROM users WHERE Playername='$player_name' LIMIT 1";

I suggest you to read whats "LIMIT 1" used for since for a while everyone here tends to reply saying it will freeze your server/host if you dont use it, when it doesnt happen and depends on the query you are executing, use a bit of common sense and re read the query again.

Select all from the table 'users' where the field 'Playername' equals to (your user name).

Now try to register the same name two or more times, i dont think so there would be two rows with the same name.

Use limit 1 if, for example, you are selecting the ammount of posts, probably 100 guys with the same post count decide to call that query at the same time, usually happens ; ) or it doesnt?.