Erreur SQL !INSERT INTO tb_cmt_react(id,message,date,pseudo_dest,pseudo_exp,id) VALUES('','vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv',NOW(),'kreen','','14') Column 'id' specified twice
<?php
//Afficher les commentaires
$q = mysql_query("SELECT * FROM tb_cmt a , utilisteurs b WHERE a.pseudo = b.pseudo ") or die(mysql_error());
$n = mysql_num_rows($q);
while($row = mysql_fetch_assoc($q)){
echo '
<table width="353" border="0" style="color: white">
<tr>
<td width="59" rowspan="2"><img src="avatar/'.$row['avatar'].'"height="45" width="45" alt="avatar" /></td>
<td width="284"><a href="index.php?page=profile2&pseudo='.$row['pseudo'].'" style=" text-decoration:none">'.$row['pseudo'].'</a></td>
</tr>
<tr>
<td>'.$row['message'].'</td>
</tr>
<tr>
<td> </td>
<td><img src="'.$row['cible'].'" height="200" width="200" /></td>
</tr>
</table>
';
echo'<a href="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'" style="text-decoration:none; color:#CCC">Commenatire</a> <br/><br/>';
if($n>0){
//Afficher les commentaires
$q2 = mysql_query("SELECT *
FROM tb_cmt_react a,utilisteurs b
WHERE a.id = '".$row['id_cmt']."'
AND a.pseudo_exp = b.pseudo
")
or die(mysql_error());
$n2 = mysql_num_rows($q2);
while($row2 = mysql_fetch_assoc($q2)){
echo '
</table>
<table width="450" border="0">
<tr>
<td width="209"> </td>
<td width="159"><table width="353" border="0" style="color: white">
<tr>
<td width="59" rowspan="2"><img src="avatar/'.$row2['avatar'].'"height="40" width="40" alt="avatar" /></td>
<td width="284"><div style="color: #FF8040"><a href="index.php?page=profile&pseudo='.$row2['pseudo_exp'].'" style=" text-decoration:none;color: #FF8040">'.$row2['pseudo_exp'].'</a></div></td>
</tr>
<tr>
<td><div style="background-color:#0D0; color:#FFF; width:auto; border-radius:10px">'.$row2['message'].'</div></td>
</tr>
</table></td>
</tr>
</table>
';}
}
}
?>
mon problème est que c'est ce ID que j'arrive pas a récupérer .
//Afficher les commentairesje voudrais recupérer
$q = mysql_query("SELECT * FROM tb_cmt a , utilisteurs b WHERE a.pseudo = b.pseudo ") or die(mysql_error());
$n = mysql_num_rows($q);
while($row = mysql_fetch_assoc($q)){.........
$row['id_cmt']
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question//Afficher les commentaires // Je sors la requête de la commande... pour pouvoir la visualiser ! $sql = "SELECT * FROM tb_cmt a , utilisteurs b WHERE a.pseudo = b.pseudo "; //------------------------------------------------------------ echo "<br> REQUETE = ".$sql."<br>"; //------------------------------------------------------------ $q = mysql_query($sql) or die(mysql_error()); $n = mysql_num_rows($q); //------------------------------------------------------------ // J'affiche le résultat de la requête pour voir ce qu'elle me donne.... //------------------------------------------------------------ echo "<br> RESULTAT DE LA REQUETE : (nb Lignes = ".$n.")<br>"; print_r($q ); echo "<br>"; //------------------------------------------------------------ while($row = mysql_fetch_assoc($q)){ echo ' <table width="353" border="0" style="color: white"> <tr> <td width="59" rowspan="2"> <img src="avatar/'.$row['avatar'].'"height="45" width="45" alt="avatar" /> </td> <td width="284"> <a href="index.php?page=profile2&pseudo='.$row['pseudo'].'" style=" text-decoration:none">'.$row['pseudo'].'</a> </td> </tr> <tr> <td>'.$row['message'].'</td> </tr> <tr> <td> </td> <td><img src="'.$row['cible'].'" height="200" width="200" /></td> </tr> </table> '; echo '<a href="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'" style="text-decoration:none; color:#CCC">Commenatire</a> <br/><br/>';
echo "<br> RESULTAT DE LA REQUETE : (nb Lignes = ".$n.")<br>";
donne :
RESULTAT DE LA REQUETE : (nb Lignes = 2)
print_r($q );
donne:
Resource id #19
Ajouter un comm
while($row = mysql_fetch_array($q)){ // Le reste de ton code...
$sql = "SELECT * FROM tb_cmt a , utilisteurs b WHERE a.pseudo = b.pseudo "; //------------------------------------------------------------ echo "<br> REQUETE = ".$sql."<br>"; //------------------------------------------------------------ $q = mysql_query($sql) or die(mysql_error()); $n = mysql_num_rows($q); $res = mysql_fetch_array($q); //------------------------------------------------------------ // J'affiche le résultat de la requête pour voir ce qu'elle me donne.... //------------------------------------------------------------ echo "<br> RESULTAT DE LA REQUETE : (nb Lignes = ".$n.")<br>"; print_r($res ); echo "<br>-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*<br>"; //------------------------------------------------------------
id_cmt] => 14
echo '<a href="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'" style="text-decoration:none; color:#CCC">Commenatire</a> <br/><br/>';.
<a href="body/extract.php?id=14&
<a href="body/extract.php?id=15&
echo '<a href="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'" style="text-decoration:none; color:#CCC">Commenatire</a> <br/><br/>';
<a href="body/extract.php?id=15&
$row['id_cmt']de chaque publication
extract.php?id='.$row['id_cmt']
echo' <div> <a href="#modalContent">Commenatire </a> <div class="modalLayer" id="modalContent"> <div class="popup_block"> '.$row['id_cmt'].' <a href="#noWhere"><img alt="Fermer" title="Fermer la fenêtre" class="btn_close" src="images/close_pop.png"></a> <h2>Saisisez vos reponses SVP </h2> <form method="post" action="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'"> <textarea name="message" rows="1" cols="50"></textarea></br> <input type="submit" value="Poster" /> </form> </div> </div> </div>';
<?php //Afficher les commentaires // Je sors la requête de la commande... pour pouvoir la visualiser ! $sql = "SELECT * FROM tb_cmt a , utilisteurs b WHERE a.pseudo = b.pseudo "; //------------------------------------------------------------ echo "<br> REQUETE = ".$sql."<br>"; //------------------------------------------------------------ $q = mysql_query($sql) or die(mysql_error()); $n = mysql_num_rows($q); $res = mysql_fetch_array($q); //------------------------------------------------------------ // J'affiche le résultat de la requête pour voir ce qu'elle me donne.... //------------------------------------------------------------ echo "<br> RESULTAT DE LA REQUETE : (nb Lignes = ".$n.")<br>"; print_r($res ); echo "<br>-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*<br>"; while($row = mysql_fetch_assoc($q)){ echo ' <table width="353" border="0" style="color: white"> <tr> <td width="59" rowspan="2"> <img src="avatar/'.$row['avatar'].'"height="45" width="45" alt="avatar" /> </td> <td width="284"> <a href="index.php?page=profile2&pseudo='.$row['pseudo'].'" style=" text-decoration:none">'.$row['pseudo'].'</a> </td> </tr> <tr> <td>'.$row['message'].'</td> </tr> <tr> <td> </td> <td><img src="'.$row['cible'].'" height="200" width="200" /></td> </tr> </table> '; echo '<a href="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'" style="text-decoration:none; color:#CCC">Commenatire</a> <br/><br/>'; echo' <div> <a href="#modalContent">Commenatire </a> <div class="modalLayer" id="modalContent"> <div class="popup_block"> '.$row['id_cmt'].' <a href="#noWhere"><img alt="Fermer" title="Fermer la fenêtre" class="btn_close" src="images/close_pop.png"></a> <h2>Saisisez vos reponses SVP </h2> <form method="post" action="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'"> <textarea name="message" rows="1" cols="50"></textarea></br> <input type="submit" value="Poster" /> </form> </div> </div> </div>'; } ?>
//Afficher les commentaires // Je sors la requête de la commande... pour pouvoir la visualiser ! $sql = "SELECT id_cmt FROM tb_cmt a , utilisteurs b WHERE a.pseudo = b.pseudo "; //------------------------------------------------------------ echo "<br>-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*<br>"; echo "<br> REQUETE = ".$sql."<br>"; //------------------------------------------------------------ $q = mysql_query($sql) or die(mysql_error()); //------------------------------------------------------------ // J'affiche le résultat de la requête pour voir ce qu'elle me donne.... //------------------------------------------------------------ while($row = mysql_fetch_assoc($q)){ echo ' <table width="353" border="0" style="color: white"> <tr> <td width="59" rowspan="2"> <img src="avatar/'.$row['avatar'].'"height="45" width="45" alt="avatar" /> </td> <td width="284"> <a href="index.php?page=profile2&pseudo='.$row['pseudo'].'" style=" text-decoration:none">'.$row['pseudo'].'</a> </td> </tr> <tr> <td>'.$row['message'].'</td> </tr> <tr> <td> </td> <td><img src="'.$row['cible'].'" height="200" width="200" /></td> </tr> </table> '; echo '<a href="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'" style="text-decoration:none; color:#CCC">Commenatire</a> <br/><br/>'; echo' <div> <a href="#modalContent">Commenatire </a> <div class="modalLayer" id="modalContent"> <div class="popup_block"> '.$row['id_cmt'].' <a href="#noWhere"><img alt="Fermer" title="Fermer la fenêtre" class="btn_close" src="images/close_pop.png"></a> <h2>Saisisez vos reponses SVP </h2> <form method="post" action="body/extract.php?id='.$row['id_cmt'].'&pseudo='.$row['pseudo'].'&masession='.$_SESSION["pseudo"].'"> <textarea name="message" rows="1" cols="50"></textarea></br> <input type="submit" value="Poster" /> </form> </div> </div> </div>'; } ?>