Own AAC problem

[kablaff]

Hello, the code below doesn't print anything in the simple AAC I'm working on.

			$result = mysql_query("SELECT id FROM accounts WHERE name= '".$accountName."';");
	  while($row[] = mysql_fetch_array($result)) {
		  echo $row[$numb][1];
		  echo '<p>';
		  $numb += 1;
	  }

And this code writes "Character name already taken" all the time

			if(mysql_query("SELECT count(*) FROM players WHERE name = '" .$charName."';") > 0) {
					die('Character name already taken!');	
			}

Any1 could solve it?

 

[Gzeep]

$result = mysql_query("SELECT id FROM accounts WHERE name= '".$accountName."';");
while($row = mysql_fetch_assoc($result)) { 
	echo $row["id"];
	echo '<p>';
}

if(mysql_num_rows(mysql_query("SELECT * FROM players WHERE name = '" .$charName."';")) > 0) {
	die('Character name already taken!');	
}

<3

50000000000000000000000000000 euro!

 

[kablaff]

The first code doesn't display anything. But thanks xd

 

[Gzeep]

its possible that you have error in database or you dont have any account - first code it must work

 

[kablaff]

Accounts exist, id exists, and I checked with "or die mysql_error()", with no result? XD

 

[kablaff]

bump !!
could it be that I'm missing some extension in wampserver php.ini?