it won't insert in the database

[devil_online]

Hi
I have this code to insert the $name into the database.
However it won't work.

 
for($i=0; $i<$numDadosNoArray; $i++)
{
    $firstnames = array("Peter", "John", "Francisco");
    $lastnames = array("Simão", "Gustavo","Gaspar");
    $nome= $firstnames[array_rand($firstnames)]." ".$lastnames[array_rand($lastnames)];

$queryNome = mysql_query("SELECT * FROM equipa WHERE jogadores='$nome'");
$numRegistos = mysql_num_rows($queryNome);

if($numRegistos==0)
{

	  mysql_query("INSERT INTO equipa (jogadores) VALUES ('$nome')");

}
} 
?>
 

How can I make it work?

thanks

[bpat1434]

try using SET....

INSERT INTO equipa SET jogadores='$nome'

The other thing to think about is that $nome actually contains the proper name, otherwise your query won't go.

You can also add an "or die(mysql_error())" statement to help debug:

mysql_query("INSERT INTO equipa (jogadores) VALUES ('$nome')" or die(mysql_error());

[devil_online]

nop..it's the same :S

[samudasu]

Did you add "or die(mysql_error());" like Bpat1434 said?? You should also add that after mysql_connect and mysql_select_db. If so then what errors are you getting? Believe it or not, that can be a tremendous help in diagnosing problems with your queries. Much better than just telling us it's not working.