27-08-2012, 12:16 PM
Oui bien sur, je copie colle mes requêtes :
Les requêtes :
L'execution :Les requêtes :
Code PHP :
<?php
include("includes/connexion.php") ;
//Ble
$sql1="UPDATE comptes SET ble = ble + 0 WHERE lvl_ble = 0"; //lvl_ble = 0
$sql2="UPDATE comptes SET ble = ble + 100 WHERE lvl_ble = 1"; //lvl_ble = 1
$sql3="UPDATE comptes SET ble = ble + 200 WHERE lvl_ble = 2"; //lvl_ble = 2
$sql4="UPDATE comptes SET ble = ble + 300 WHERE lvl_ble = 3"; //lvl_ble = 3
$sql5="UPDATE comptes SET ble = ble + 400 WHERE lvl_ble = 4"; //lvl_ble = 4
$sql6="UPDATE comptes SET ble = ble + 500 WHERE lvl_ble = 5"; //lvl_ble = 5
$sql7="UPDATE comptes SET ble = ble + 600 WHERE lvl_ble = 6"; //lvl_ble = 6
$sql8="UPDATE comptes SET ble = ble + 700 WHERE lvl_ble = 7"; //lvl_ble = 7
$sql9="UPDATE comptes SET ble = ble + 800 WHERE lvl_ble = 8"; //lvl_ble = 8
$sql10="UPDATE comptes SET ble = ble + 900 WHERE lvl_ble = 9"; //lvl_ble = 9
$sql11="UPDATE comptes SET ble = ble + 1000 WHERE lvl_ble = 10"; //lvl_ble = 10
Code PHP :
<?php
if (!mysql_query($sql1,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql2,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql3,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql4,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql5,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql6,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql7,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql8,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql9,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql10,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
if (!mysql_query($sql11,$con))
{
die('Une erreur est survenue.<br />
' . mysql_error());
}
echo "yessss<br />
";
?>