nouvelle edition
------------------info.php---------------------------
<? include("connect.php");
$team= ($HTTP_GET_VARS['team']);
$match= ($HTTP_GET_VARS['match']);
$renc= ($HTTP_GET_VARS['renc']);
$connect=mysql_connect($shost,$suser,$spass);
mysql_select_db($sbase, $connect);
$REQ="SELECT * FROM game WHERE match='$renc' ";
//ce if permet de tester si la requete est bonne
if (!($rep=mysql_query($REQ)))
{echo 'Problème de requête : '.$REQ;
// $link contient l'identification de la connexion au serveur MySQL
echo mysql_error($link);
exit;
};
while ($donnees = mysql_fetch_array($result)){
if (($match)==($team)){
echo "<tr>";
echo "<br><br>";
echo " <td width=\"100%\" height=\"50\"><center>Null</center></td>";
echo " </tr>";
echo "</table><br><br><br>";
}
else{
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" height=\"80\">";
echo " <td width=\"100%\" height=\"10\">Date:" . $donnees['date'] . "</td>";
echo "<tr>";
echo "<td>";
echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" height=\"60\">";
echo " <tr>";
echo " <td width=\"35%\" height=\"10\">gagner</td>";
echo " <td width=\"35%\" height=\"10\">perdu</td>";
echo " <td width=\"30%\" height=\"10\">pts</td>";
echo " </tr>";
echo "<tr>";
echo " <td width=\"35%\" height=\"50\">" . $donnees['gagner'] . "</td>";
echo " <td width=\"35%\" height=\"50\">" . $donnees['perdu'] . "</td>";
echo " <td width=\"30%\" height=\"50\">" . $donnees['points'] . "</td>";
echo " </tr>";
echo "</table><br><br><br>";
echo "</tr>";
echo "</td>";
echo "</tr>";
}
}
mysql_close($connect);
?>
sa donne errur sur la ligne 12
Problème de requête : SELECT * FROM game WHERE match='aa'
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
.\info.php on line
12
Problème de requête : SELECT * FROM game WHERE match='ab'
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
.\info.php on line
12echo mysql_error($link); ben doit etre erroné ??
ben a de suite lol