Name generation

[Anon]

I having a problem with creating a name generation script and was hoping either if someone can help or has one already created..

What I am trying to do is create, something similar to the zone.com, which is when someone signs up and a member name is taken it supplies alternative names.

Example: one enters garry and garry, garry1, garry2 happen to be taking so it would display garry3, garry_toronto, etc.. as alternatives...

[Anon]

You would have to store the names in say a database table and query that to find if the alternative are taken.

i.e.

for mysql it could be like...

<?

$name="gary";

db connect goes here.

$query="select * from nametable where username like '".$name."'";

$result=mysql_query($query, $dbconnection);

if ( mysql_num_rows($result) )
{
echo "The name ".$name."has been taken ";
echo "how about :<P>";
for ( $temp=1; $temp<10; $temp++ )
{
$query="select * from nametable where username like '".$name.$temp."'";

    $result=mysql_query($query, $dbconnection);
    if ( mysql_num_rows($result) <= 0 )
    {
        echo $name.$temp."<BR>";
    }
} 

}

?>

I think thats correct if should return a list of the names 1 - 10 if they are not taken.

Mark.

[Anon]

not quit working but it gives me a starting point to work from.. many thanks