Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in client_voir.php on line 66
C lerreur que j obtient dans ce code..
<html><head><title>M&M Corp.</title></head><body bgcolor=silver><?
include("config.php3");
echo "<div align=center><br><font face=$txt_face size=$txt_size color=$txt_color><b>Détails client #$id:</b><br><br>";
mysql_select_db($db_base);
$sql = "SELECT * FROM clients WHERE id = $id";
$result = mysql_query($sql) or die(mysql_error());
while ($mmcorp = mysql_fetch_array ($result)) {
$nom = $mmcorp['nom'];
$email = $mmcorp['email'];
$sexe = $mmcorp['sexe'];
$ville = $mmcorp['ville'];
$telephone = $mmcorp['telephone'];
echo "<table border=0>";
echo "<tr>";
echo "<td width= align=right><font size=2 face=Verdana><b>Id:</b></font></td>";
echo "<td width=><font face=$txt_face size=$txt_size color=$txt_color>$id</td>";
echo "</tr>";
echo "<tr>";
echo "<td width= align=right><font size=2 face=Verdana><b>Nom:</b></font></td>";
echo '<td width=><font size=2 face=Verdana color=black>'.$nom.'</td>';
echo "</tr>";
echo "<tr>";
echo "<td width= align=right><font size=2 face=Verdana><b>E-Mail:</b></font></td>";
echo '<td width=><font size=2 face=Verdana color=black>'.$email.'</td>';
echo "</tr>";
echo "<tr>";
echo "<td width= align=right><font size=2 face=Verdana><b>Sexe:</b></font></td>";
echo '<td width=><font size=2 face=Verdana color=black>'.$sexe.'</td>';
echo "</tr>";
echo "<tr>";
echo "<td width= align=right><font size=2 face=Verdana><b>Ville:</b></font></td>";
echo '<td width=><font size=2 face=Verdana color=black>'.$ville.'</td>';
echo "</tr>";
echo "<tr>";
echo "<td width= align=right><font size=2 face=Verdana><b>Téléphone</b></font></td>";
echo '<td width=><font size=2 face=Verdana color=black>'.$telephone.'</td>';
echo "</tr>";
echo "</table><br><br>";
}
$db_host = "sql.free.fr"; /* L'adresse du serveur */
$db_user = "ina"; /* L'utilisateur pour la connexion */
$db_pass = "ma"; /* Le mot de passe pour la connexion */
$db_base = "ina"; /* Le nom de la base de données */
$connex = mysql_connect($db_host, $db_user, $db_pass); /* Connexion a la base */
/* Configuration du site web */
$admin = "admin"; /* Identifiant de l'administrateur */
$admin_pass = "maxxix"; /* Mot de passe de l'administrateur */
$banner = "images/banner.jpg"; /* Adresse de la banniere */
$txt_size = "2"; /* Grosseur du texte */
$txt_color = "black"; /* Couleur du texte */
$txt_face = "Verdana"; /* Style du texte */
$pge_background = "silver"; /* Couleur d'arriere-plan de la page */
$pge_title = "M&M Corp."; /* Titre de la page */
echo "<table border=0 cellspacing=0 width=><tr><td width= <p align=center><font face=Verdana size=2><u>Commandes:</u></font></p></td></tr><tr>";
echo "<td width=>
<p align=left><table border=0 width=516>
<tr><td width=23><font size=2 face=Verdana>Id</font></td>
<td width=186><font size=2 face=Verdana>Jeux</font></td>
<td width=62><font size=2 face=Verdana>Prix</font></td>
<td width=><font size=2 face=Verdana>Status</font></td>
</tr>";
mysql_select_db($db_base);
$sql2 = "SELECT * FROM commandes WHERE client = $client";
$resultat = mysql_query($sql2);
while ($mmcorp = mysql_fetch_array($resultat))
{
$id = $mmcorp['id'];
$jeux = $mmcorp['jeux'];
$prix = $mmcorp['prix'];
$status = $mmcorp['status'];
echo "<tr>";
echo "<td width=><font face=$txt_face size=$txt_size color=$txt_color>$id</td>";
echo "<td width=><font face=$txt_face size=$txt_size color=$txt_color>$jeux</td>";
echo "<td width=><font face=$txt_face size=$txt_size color=$txt_color>$prix</td>";
echo "<td width=><font face=$txt_face size=$txt_size color=$txt_color>$status</td>";
echo "</tr>";
}
echo "</table>";
echo "<br><br><font face=$txt_face size=$txt_size color=$txt_color><a href=admin.php3>Back</a></div>";
?>
</body></html>
Connexion
Inscription
FAQ
Rechercher
