[xantowskii]

Quote:

Originally Posted by kirk 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?.

LIMIT acts as a INDEX key and it optimizes your Query. If you have 100k accounts it would take long to load the data, LIMIT statement makes it quicker. And not making use of it is really a stupid idea (especially in MyISAM engine).

Quote:

Originally Posted by Nodroz Well, that could be yes. However, you can only have 1 same playername in the database... so I don't think it'll change anything to the result.

LIMIT is used to Optimize the query. I didn't say anything about player name.