Probleme dans mon script instant gagant

Bonjour,
juste pour savoir si quelqun a une idee
merci

<?php
$hostname_Connex = '127.0.0.1';
$database_Connex = 'base';
$username_Connex = 'root';
$password_Connex = 'rien';
$connection = mysql_pconnect($hostname_Connex, $username_Connex, $password_Connex) or die(mysql_error());
$query4=mysql_select_db($database_Connex, $connection);
$query4="LOCK TABLES pointspeed WRITE";
$result4 = mysql_query($query4, $connection) OR die('error making querya');
$query="update pointspeed set nombre=nombre+1";
$result4 = mysql_query($query, $connection) OR die('error making queryb');
$query2="select * from pointspeed";
$result2 = mysql_query($query, $connection) OR die('error making queryc');
$data2=mysql_fetch_array($result2);
if ($data2[nombre]==10) {
echo 'gagne';
$query3="update pointspeed set nombre=0";
$result3 = mysql_query($query3, $connection) or die('error making query');
}
else {
echo 'perdu';
}
$query5="UNLOCK TABLES";
$result5 = mysql_query($query5, $connection) or die('error making query');

?>