Need help creating a loop..

dotcomtim

I am trying to create a loop and so far not very successful at doing so. The script is to check if a username is available and if it isn't check for the next available username + 1.
Here is the original script before I got caught up in to many errors.

$check_username = DBGetValue ("SELECT username FROM ".USER_TABLE." " .
"WHERE username = '".addslashes ($username)."' ");
if ((isset($check_username ))
{
$errs['username'] = 'The user name you requested is already in use';

$username_count = $username_count + 1;
$username_count = $username.$username_count;

}
If I enter the username dotcomtim and is taken then dotcomtim1 is given as an alternative. But if dotcomtim1 is also taken then the loop goes to the next available username ... dotcomtim2 and so on. But I am running into problems with my loop to make this work.

What PHP function should I be using?

matt_4013

This should work for you


do {

$check_username = DBGetValue ("SELECT username FROM ".USER_TABLE." " . "WHERE username = '".addslashes ($username)."' "); 
if (isset($check_username )) { 

$username_count = $username_count + 1; 
$username = $username.$username_count; 
$inuse = True;

} else {

$errs['username'] = "The user name you requested is already in use, try $username!";
$inuse = False;

}

} while($inuse);

dotcomtim

Thanks for your help matt .. I started working on what you gave and it got rid of some of errors that I was getting..

But it must of been what I did in my scripting .. with your loop I am getting the following dotcomtim11 if dotcomtim and dotcomtim1 are taken .. what should I have done to get dotcomtim2?

matt_4013

Instead of $username_count = $username_count + 1; make it:

$username_count++;

dotcomtim

When I use the following script to find the next available username..

do {

$check_username = DBGetValue ("SELECT username FROM ".USER_TABLE." " . "WHERE username = '".addslashes ($username)."' ");
if (isset($check_username )) {

$username_count = $username_count + 1;
$username = $username.$username_count;
$inuse = True;

} else {

$errs['username'] = "The user name you requested is already in use, try $username!";
$inuse = False;

}

} while($inuse);

or even with the latest change

do {

$check_username = DBGetValue ("SELECT username FROM ".USER_TABLE." " . "WHERE username = '".addslashes ($username)."' ");
if (isset($check_username )) {

$username_count++;
$username = $username.$username_count;
$inuse = True;

} else {

$errs['username'] = "The user name you requested is already in use, try $username!";
$inuse = False;

}

} while($inuse);

I am getting the following error after the page hanging for quite I long time:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 10240 bytes) ... Did I do the loop correct or do I have PHP problem?