How do I put extra number at the end of username if duplicate
<p>Hard to explain, and let me show an example.</p>

<ol>
<li>If username <strong>foo</strong> already exists in MySQL I want php script will allow it but to be <strong>foo1</strong></li>
<li>Then if <strong>foo1</strong> exists too, script will generate the username will be <strong>foo2</strong></li>
<li>If <strong>foo2</strong> existed then become <strong>foo3</strong></li>
</ol>

<p>How to make like that?</p>

<p>Like <a href="http://stackoverflow.com/questions/4498886/how-do-i-put-extra-number-at-the-end-of-username-if-duplicate/4499014#4499014">Col. Shrapnel</a> said <em>Natural increment which seems more sensible. just like "New Folder(3)" stuff in Windows</em></p>
