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 : Sélectionner tout - Visualiser dans une fenêtre à part
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') ";
		}
	}