Vérifier si l'utilisateur existe

Version imprimable

j'ai ce petit code qui fais des merveille mais je reçois un mouvais résulta
résulta:
user
user1
user12
user123
user1234
etc...

ce que je veut recevoir
user
user1
user2
user3
user4
etc...

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
$result = mysql_query("SELECT userName FROM members WHERE userName='$userName'",$connection);
	$num_rows = mysql_num_rows($result);
	if ($num_rows > 0){
		$count = 1;
		While ($num_rows > 0){
			$newname = $userName.$count;
			$result = mysql_query("SELECT userName FROM members WHERE userName='$newname'",$connection);
			$num_rows = mysql_num_rows($result);
			$userName = $newname;
			$count = $count + 1;
			$sql = "INSERT INTO members (userName) VALUES ('$userName') ";
		}
	}

c'est parce que le ".$count" rajoute chaque fois le nombre

essaye ça :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
$compteur = 0;
 
do {
    $compteur++;
    $recherche = $userName . $compteur;
 
    $rechercheSQL = mysql_real_escape_string($recherche);
 
    $requete = "SELECT userName FROM members WHERE userName='$rechercheSQL'";
 
    $result = mysql_query($requete, $connection) or exit(mysql_error());
    $num_rows = mysql_num_rows($result);
} while ($num_rows > 0);
 
 
$requete = "INSERT INTO members (userName) VALUES ('$rechercheSQL')";
$result = mysql_query($requete, $connection) or exit(mysql_error());

16/02/2008, 11h24
wzcocoon

merci beaucoup ca marche super...